topic From Date format to number format in QlikView

From Date format to number format

zagzebski — Tue, 30 Jul 2013 17:51:45 GMT

I don't understand a date field I have. It makes it through two layers of scripting and appears as a date, but in the final model it turns to a number. Can someone tell me why it would change in the final model?

My EFFECTIVE DATE field:

Base Load - 7/21/2013

ETL Load - 7/21/2013

Final Model - 41476

Re: From Date format to number format

Gysbert_Wassenaar — Tue, 30 Jul 2013 18:01:54 GMT

A date is actually a number. With the date() function it can also be given a text format. It will still be a number, but now also has a display text format. So in the load script you can put the date() function around it to give it a date format of your choice: date([EFFECTIVE DATE], 'DD-MM-YYYY') as [EFFECTIVE DATE]

Re: From Date format to number format

zagzebski — Tue, 30 Jul 2013 19:42:18 GMT

Thanks! I guess I understand that just couldn't figure why in the first two scripts it has the date MM/DD/YYYY format, then in the final model it switched to a number format. How does the same field have a different format as it works its way through several scripts?