Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
tmumaw
Valued Contributor

Evaluating Date

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

Labels (1)
1 Solution

Accepted Solutions

Re: Evaluating Date

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]

 

3 Replies

Re: Evaluating Date

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
New Contributor II

Re: Evaluating Date

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
Valued Contributor

Re: Evaluating Date

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