topic Date( ) vs Date#( ) ??? in QlikView

Date( ) vs Date#( ) ???

Wed, 06 Oct 2010 06:01:18 GMT

Hi all,

Can anyone please explain me the Date() and Date#()functions???

What is the difference when using hash(#)??

Thanks and Regards,

Nilupa

Wed, 06 Oct 2010 06:27:50 GMT

Hi,

Date() is used to extract the date from your time stamp.

Ex1:

Let consdider date field as 06:10:2010 09:55:34,when you using this date() it will give your date field as 06:10:2010

Then Date#() is formatting funtion

Let consider your date field as 2010:10:06,when you use date#(date_field,'DD-MM-YYYY') it will give you result as 06:10:2010

Thanks & Regards

Jai

Wed, 06 Oct 2010 06:33:50 GMT

Hi,

Thanks.......

we can use


Date(Datefield,'DD/MM/YYYY')

to format the date.... So why date# ?

Thanks and Regards,

Nilupa

Wed, 06 Oct 2010 06:53:27 GMT

Hi,

Date# is used when value is not in Date format.

Many times values are like 23645. To convert it in equivalent Date format,

we use Date#.

When Date is in Date format itselft..say..DD/MM/YYYY and we want in DD-MMM-YY format,

we use Date only.

Hope this clarifies the difference.

Happy Thoughts

Wed, 06 Oct 2010 07:03:52 GMT

Thanks