Evaluating Date

[tmumaw]

Good morning everyone,

Easy question for you.  I'm trying to evaluate a date field and it's retuning 1899-12-30.  Any ideas what I might be doing wrong?  Here is my statement.   The source of the date is an excel file.  The contents are:

Profit Center  Customer  Date (format)

123456                99999999        1/17/2018

date(evaluate(Periods), 'YYYY-MM-DD') as [Billing Date],

[sunny_talwar · Accepted solution]

May be try this instead

Date(Periods, 'YYYY-MM-DD') as [Billing Date]

or this

Date(Date#(Periods, 'M/D/YYYY'), 'YYYY-MM-DD') as [Billing Date]

[volakakis]

evaluate(Periods) will actually do this division: 1/17/2018 = 0.000029....

Date(0.000029) = 1899-12-30

Try the other way around evaluate(date(Fieldname)) not that I understand why you want to use the evaluate funtion

Nikos

[tmumaw]

Thanks Sunny that worked perfect.  What's strange I use the same logic with another file and it works fine......