topic Re: Date in Script in QlikView https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230140#M392056 <HTML><HEAD></HEAD><BODY><P>Format code for month is MM, not mm (which denotes minutes):</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'MM/DD/YYYY'</SPAN></P></BODY></HTML> Tue, 07 Feb 2017 21:12:47 GMT swuehl 2017-02-07T21:12:47Z Date in Script https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230139#M392055 <HTML><HEAD></HEAD><BODY><TABLE><TBODY><TR><TD>Date(Interval(nwEVENTDTE - 56, 'd'),'mm/dd/yyyy')</TD><TD>AS</TD><TD></TD><TD><P><SPAN style="font-size: 10pt;">EightWeeks</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>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.</P><P></P><P>Am I formatting this incorrectly in the script?</P></BODY></HTML> Tue, 07 Feb 2017 21:09:20 GMT https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230139#M392055 evansabres 2017-02-07T21:09:20Z Re: Date in Script https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230140#M392056 <HTML><HEAD></HEAD><BODY><P>Format code for month is MM, not mm (which denotes minutes):</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'MM/DD/YYYY'</SPAN></P></BODY></HTML> Tue, 07 Feb 2017 21:12:47 GMT https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230140#M392056 swuehl 2017-02-07T21:12:47Z Re: Date in Script https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230141#M392057 <HTML><HEAD></HEAD><BODY><P>Besides this, no need to format the inner calculation:</P><P></P><P>Date(nwEVENTDTE - 56,'MM/DD/YYYY') AS <SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">EightWeeks</SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P></BODY></HTML> Tue, 07 Feb 2017 21:14:08 GMT https://community.qlik.com/t5/QlikView/Date-in-Script/m-p/1230141#M392057 swuehl 2017-02-07T21:14:08Z