Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
koushik_btech20
Contributor

Major Date problem

There is an serious date problem . In the database the entry of the data is not correct in some place, example- date is 30111124(YYYYMMDD format) where year is 3011 which is not possible. But in the database there is a filed named as PERIOD, where PERIOD is 2011008 where 2011 is the financial year and 008 is the financial month which is November but date is 30111124(YYYYMMDD format) using PERIOD how to extract the correct date from the database?...  I have already attached an excel file ... If anyone have the answer plz share with example......

1 Reply

Re: Major Date problem

Hi,

     Try something like this.

     Load date(date#(left(text(Period),4)&right(text(Trans_Date),4),'YYYYMMDD')) as Date

     From xyz.

Regards,

Kaushik Solanki

Community Browser