Unable to create another column where date is 30 days more (or less)

[Laurie Huth]

I've tried everything and the results always come up to "Undefined Nan" error message

SELECT 'Key',T1.'Due',
FORMATWIKI(SUM('Summary')) AS 'Summary 2',
FORMATWIKI(SUM("*" + 'Summary' + "*" + ", Due " + 'Due')) AS 'Summary',
FORMATWIKI(SUM('Due' + 30)) AS 'added',
FORMATWIKI(SUM('Due')) AS 'Due Date',
FORMATWIKI(SUM('Due')) AS 'Due Date 2',

Here are two options I've tried:

• FORMATDATE(DATE_SUB(T1.'Due', INTERVAL 30 DAY)) as 'After',
• FORMATDATE(DATEADD(DD,30,'Due')) AS 'After2',

I don't understand what I'm doing wrong and I've spent way to long trying to resolve this. :-(

[Laurie Huth]

Update: If I just write the following as standalone, it works. However, I am not allowed to add any other lines with errors.

SELECT 'Key',

FORMATDATE(DATEADD(day, -30, Due)) AS BeforeDate

FROM T1