Date Format in Script

[Anonymous]

Hello,

I would like to create a variable on my script with a specific Date Format. I tried this:

But when i look into the data structure i see this:

The Format doesn't work :/.

I need this because i do a check between two variables:

AsOf_E = Last_Update_Projection

And AsOf_E is configured like this:

Thanks you in advance for your help,

Sébastien.

[PrashantSangle]

Hi,

Use date() instead of date#()

Regards

[MK_QSL]

Date(Date#(Max(AsOf_E,'DD/MM/YYYY')) as

[Chanty4u]

try

Load,

Date(Date#(Max(Asof_E,'Dateformat')) as new

[Kushal_Chawda · Accepted solution]

just Date function will work

MaxDate:

LOAD

Date(Max(AsOf_E) ,'DD/MM/YYY')  as [LastAsOf]

...

LET Last_Update_Projection = peek('LastAsOf',0,'MaxDate');

[#6]

Hi ,

Load Date(Date#(Max(Asof_E,'DD/MM/YYYY')) as [LastAsOf]

[sunny_talwar]

I think Manish you forgot to close Max() function

[sunny_talwar]

Not sure if Date#() function is still required to interpret the date.

Date(Date#(Max(AsOf_E),'DD/MM/YYYY'), 'DD/MM/YYYY') as [LastAsOf]