topic How to make date? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308934#M1199544 <HTML><HEAD></HEAD><BODY><P>hello peter</P><P></P><P>well i tried makedate() but its give me 3/1/2001 something like that so thought its not working well.</P><P>i figure it out. that date format isnt right. so i used</P><P>date(makedate(year+2000,month), 'YYYYMMDD');</P><P>now its look like give me correct date format.</P><P>sorry for typed newbie question.</P><P>Thank you peter</P></BODY></HTML> Sun, 27 Feb 2011 18:48:36 GMT 2011-02-27T18:48:36Z How to make date? https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308932#M1199542 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P>Im new in QV.</P><P>well i have 2 fields like this.</P><P>month:</P><P>1, 2, 3, 4, 5, 6, 7,...</P><P>year:</P><P>1, 2, 3, 4, 5, 6, 7, 8...</P><P>i have to make them date.</P><P>year 1 is mean 2001, 2 = 2002...</P><P>how should i do this. please anyone help me.</P><P></P></BODY></HTML> Sun, 27 Feb 2011 17:58:03 GMT https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308932#M1199542 2011-02-27T17:58:03Z How to make date? https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308933#M1199543 <HTML><HEAD></HEAD><BODY><P>MAKEDATE(YourYear + 2000, YourMonth) should deliver the 1st of each month.</P><P>HTH<BR />Peter</P></BODY></HTML> Sun, 27 Feb 2011 18:30:59 GMT https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308933#M1199543 prieper 2011-02-27T18:30:59Z How to make date? https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308934#M1199544 <HTML><HEAD></HEAD><BODY><P>hello peter</P><P></P><P>well i tried makedate() but its give me 3/1/2001 something like that so thought its not working well.</P><P>i figure it out. that date format isnt right. so i used</P><P>date(makedate(year+2000,month), 'YYYYMMDD');</P><P>now its look like give me correct date format.</P><P>sorry for typed newbie question.</P><P>Thank you peter</P></BODY></HTML> Sun, 27 Feb 2011 18:48:36 GMT https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308934#M1199544 2011-02-27T18:48:36Z How to make date? https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308935#M1199545 <HTML><HEAD></HEAD><BODY><P>The MAKEDATE should already deliver you a date in the format as in the initial lines of the script under</P><P>SET DateFormat = ....</P><P>If you wish to change all your date-display as YYYYMMDD, you should be able to write this into the above statement.</P><P>HTH<BR />Peter</P></BODY></HTML> Sun, 27 Feb 2011 18:55:26 GMT https://community.qlik.com/t5/QlikView/How-to-make-date/m-p/308935#M1199545 prieper 2011-02-27T18:55:26Z