Difference b/w date and date# with exp please.... - Qlik Community

Report Inappropriate Content · ‎2013-04-02

Help me on this....

kaushiknsolanki · ‎2013-04-02

Hi,

The Date function will convert the numbers into date format, you can also define the date format. Something like this.

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

If you dont define the format, it takes the default one i.e MM/DD/YYYY

Date# Function is used to convert the text into date.

Date#('13/03/2003','DD/MM/YYYY')

Here you need to define the format in which your text is. Like in above example I have used "DD/MM/YYYY" Cause the example date is that format.

Hope this is clear.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!