1 Reply Latest reply: Mar 28, 2013 2:27 PM by Kaushik Solanki RSS

    Major Date problem

    Koushik Banerjee

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