topic Re: Date And Date# function in QlikView

Date And Date# function

tripatirao — Wed, 30 Sep 2015 09:59:43 GMT

I want to know about difference between Date and Date# function .

Thanks

Re: Date And Date# function

qlikviewwizard — Thu, 01 Oct 2015 02:27:05 GMT

Hi,

Please check the attached screens and script.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Data:

Load *, date(date#(Trans_Date,'YYYYMMDD'),'DD-MMM-YYYY') as Another_Required_Date_Format; // convert the date to DD-MMM-YYYY

load *,date(date#(Trans_Date,'YYYYMMDD'),'DD/MM/YYYY') as Required_Date_Format;/// conevrt the date to DD/MM/YYYY

LOAD * ,DATE#(Trans_Date,'YYYYMMDD') AS Real_Trans_Date; ///converted to date to same format YYYYMMDD

load * inline [

Trans_Date

20140125

20140205

20140329

20140415

20140520

];

Re: Date And Date# function

prma7799 — Thu, 01 Oct 2015 02:53:29 GMT

Please go through below link

Difference between Date,Date# and Num,Num#????

Re: Date And Date# function

prma7799 — Thu, 01 Oct 2015 02:54:18 GMT

also check

https://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function

Thanks

Re: Date And Date# function

SreeniJD — Thu, 01 Oct 2015 04:49:51 GMT

In Simple words...

Date# will be useful to convert the string to different date format

Date will be restricted to convert a date to another date format.

HTH

Sreeni

Re: Date And Date# function

Thu, 01 Oct 2015 05:13:58 GMT

Date() converts date to the required format. Also, it stores a date as number in the back-end and show you as a date

Qlikview is intelligent to find date field and covert to date format during the load. Incase Qlikview did not recognize the format and treats data type as a string. Date#() is used to help Qlikview interpret it as a date format.