topic DATE#() or DATE() - what's the difference ? in QlikView

DATE#() or DATE() - what's the difference ?

Thu, 25 Feb 2010 20:14:03 GMT

Hello !

I have several scripts that load data from CSV files.

On those files, dates are like this : 25/02/2010 .

How should I load them on my scripts ?

I could use one of those forms below :

DATE (DATE_FIELD,'DD/MM/YYYY') AS DATE1_FIELD
DATE#(DATE_FIELD,'DD/MM/YYYY') AS DATE2_FIELD

But I dont know what's the difference between them.

It is a FACT that DATE2_FIELD , when exported to Excel, wont go WELL formatted. And this is really a problem.

There's an attached QVW where you can this bug.

The same doubt I have when dealing with numeric fields. Should I use NUM() or NUM#() to "force" the number field interpretation ?

Thanks !

boorgura — Thu, 25 Feb 2010 21:12:40 GMT

hey Adriano,

the Date#() function returns the number equivalent to the date passed into it.

and of course the date() function is the one to convert a string or change the format of a date.

Let me know if that's not clear.

Thanks,

Rocky.

Fri, 26 Feb 2010 13:23:53 GMT

Hello Rocky !

Thanks for your help.

I guess the problem is way more tricky than what I supposed.

Take a look at this other post :

http://community.qlik.com/forums/t/26176.aspx

It's more explained there.

Thanks again !