topic Evaluating Date in QlikView

Evaluating Date

tmumaw — Sat, 16 Nov 2024 04:47:38 GMT

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],

Re: Evaluating Date

sunny_talwar — Thu, 10 Jan 2019 13:56:48 GMT

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]

Re: Evaluating Date

volakakis — Thu, 10 Jan 2019 14:23:46 GMT

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

Re: Evaluating Date

tmumaw — Thu, 10 Jan 2019 14:24:18 GMT

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