Date in Script

[evansabres]

Date(Interval(nwEVENTDTE - 56, 'd'),'mm/dd/yyyy')

AS

EightWeeks

A line in my script appears as above. However, when I load the script and view the data, the field displays as 00/03/2016, which should be 11/03/2016.

Am I formatting this incorrectly in the script?

[swuehl · Accepted solution]

Format code for month is MM, not mm (which denotes minutes):

'MM/DD/YYYY'

[swuehl]

Besides this, no need to format the inner calculation:

Date(nwEVENTDTE - 56,'MM/DD/YYYY') AS EightWeeks