topic I need a Date Time Function to create a Integer Date in format YYYYMMDD? in QlikView https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238448#M393630 <HTML><HEAD></HEAD><BODY><P>I want to convert the current date to an integer value in the format YYYYMMDD. </P><P></P><P>For example, Today is 12/09/2016 in MM/DD/YYYY format and converted to YYYYMMDD is 20161209.</P><P>I would be using the today() or now() function as the source of the date.</P><P></P><P>Can any provide an example in how to do this in Qlik script?</P></BODY></HTML> Fri, 09 Dec 2016 16:27:30 GMT aritting 2016-12-09T16:27:30Z I need a Date Time Function to create a Integer Date in format YYYYMMDD? https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238448#M393630 <HTML><HEAD></HEAD><BODY><P>I want to convert the current date to an integer value in the format YYYYMMDD. </P><P></P><P>For example, Today is 12/09/2016 in MM/DD/YYYY format and converted to YYYYMMDD is 20161209.</P><P>I would be using the today() or now() function as the source of the date.</P><P></P><P>Can any provide an example in how to do this in Qlik script?</P></BODY></HTML> Fri, 09 Dec 2016 16:27:30 GMT https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238448#M393630 aritting 2016-12-09T16:27:30Z Re: I need a Date Time Function to create a Integer Date in format YYYYMMDD? https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238449#M393631 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>This is still date, but in the required format</P><P><STRONG>LOAD Date(Today(), 'YYYYMMDD') as Date</STRONG></P><P></P><P>or</P><P>This is a number now</P><P><STRONG>Num#(Date(Today(), 'YYYYMMDD'), '##') as DateNumber</STRONG></P></BODY></HTML> Fri, 09 Dec 2016 16:31:46 GMT https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238449#M393631 sunny_talwar 2016-12-09T16:31:46Z Re: I need a Date Time Function to create a Integer Date in format YYYYMMDD? https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238450#M393632 <HTML><HEAD></HEAD><BODY><P>yes, that works in a Load statement and expression</P><P></P><P>Num#(Date(Today(), 'YYYYMMDD'), '##') as DateNumber</P><P></P><P>or</P><P>LET vL.MyVar = Num#(Date(Today(), 'YYYYMMDD'), '##');</P></BODY></HTML> Fri, 09 Dec 2016 17:42:18 GMT https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238450#M393632 aritting 2016-12-09T17:42:18Z Re: I need a Date Time Function to create a Integer Date in format YYYYMMDD? https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238451#M393633 <HTML><HEAD></HEAD><BODY><P>Thank you very much!</P></BODY></HTML> Fri, 09 Dec 2016 17:42:35 GMT https://community.qlik.com/t5/QlikView/I-need-a-Date-Time-Function-to-create-a-Integer-Date-in-format/m-p/1238451#M393633 aritting 2016-12-09T17:42:35Z