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