topic what difference between two function[ date(),date#() ] in QlikView

what difference between two function[ date(),date#() ]

Tue, 20 Jul 2010 12:02:45 GMT

What is difference between these two function.

1) date()

2) date#()

Regards

Ashish Srivastava

what difference between two function[ date(),date#() ]

shumailh — Tue, 20 Jul 2010 12:26:50 GMT

The only difference i found here is the date function accepts the expressions having values in numeric form like i.e. 35648 whereas date# is only use to evaluate the date data expression.

Regards,
Shumail

what difference between two function[ date(),date#() ]

Tue, 20 Jul 2010 12:56:10 GMT

date() takes a number that can be expressed as a date and expresses it in the default format unless otherwise specified.

e.g. Date(40379) may return a 20/07/2010 and date(40379,'MM-DD-YYYY') would return 07-20-2010

date#() will take in a date in an odd format and convert it to a date format. e.g. in my database we have a date in the format yyyymmdd

so date#('20100720','YYYYMMDD') would make this recognisable as a date. so to get that in the same format as above you would have to perform the date() function on it.

e.g. date(date#('20100720','YYYYMMDD'))

returns '20/07/2010'