Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

rido1421
Not applicable

Cannot Convert Date string

Hi All

I have a set of data with the date field that I am converting to month, year and day

this is the format of the date 20100301

Year(INVDATE) as Year,

Month(INVDATE) as Month,

Day(INVDATE) as Day

The Month and Day fields are working correctly as required the year field is returning 56933 and 56934

I usually use this method and cannot understand why it isnt working for the year field im assuming this is the epoc date?

Please could you advise

1 Solution

Accepted Solutions
jebamalai
Not applicable

Re: Cannot Convert Date string

Try with Left,Right and Mid functions to convert

4 Replies
jebamalai
Not applicable

Re: Cannot Convert Date string

Try with Left,Right and Mid functions to convert

rido1421
Not applicable

Re: Cannot Convert Date string

Thank you the left function solved my issue

jebamalai
Not applicable

Re: Cannot Convert Date string

Great,Pls close the conversation with answered

qlikoqlik
Not applicable

Re: Cannot Convert Date string

Hi

Try setting the format setting to date under the number tab on chart properties

regards

Padma