Major Date problem

[koushik_btech20]

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......

[kaushiknsolanki]

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