Date() vs Date#()

[#1]

Can someone illustrate the difference between the two?

[Anonymous · Accepted solution]

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

Regards,

Michael

[#3]

Very helpful.  Thanks!

[#4]

I have an issue with date() and date#(),i have field called ActionDate which is in this format 'DD/MM/YYYY'

and I have a field in the script  that calculates DDMM  like this

date#(date(CalendarDate,'DDMM'),'DDMM') Do you think there is a redundancy in this expression? thank you

[MK_QSL]

You can read this useful document.

[#6]

Thank you for your help Manish.

[#7]

thank you it was a nice Demo

[#8]

use this document which is very helpful