Quelles est la différence entre date() et date#() dans Qlikview ?

0
56

Date() is to format a number as date string / text, Date#() to interpret a string as date number.

 

Date#() is used how to interpret the data.  For example

date#(‘2013_24_10′,’YYYY_DD_MM’) tells that the first four digits are year, the digits between two ‘_’s are Date, and the last two are Month.

Date() is used to tell how to show the data.  For example

date(today(),’YYYY_DD_MM’) returns  2013_24_10

date(today(),’MM/DD/YY’) returns  10/24/13

Combination of both:

date(date#(‘2013_24_10′,’YYYY_DD_MM’),’MM/DD/YYYY’) returns 10/24/2013

 

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here