Force date to be stored as number in CSV

[bhimes10000]

How can I force a date to be stored as a number in a CSV? I have tried stripping off the $date tag from the field, adding 0 to it, reloading the field using date#, and reloading the field using num#. Any advice on how to get the Qlik equivalent of Excel's datevalue?

The csv file should store '12/31/2013' as 41639.

[nagaiank]

Num(Date#('12/31/2013')) returns 41639

[hic]

I would do exactly the same as NagaianK. To understand what happens, you should read about interpretation vs. formatting and about dual fields:

QlikView Date fields

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/13/dual

HIC