I need your Assistance to Check whether a Particular date value is really a Valid date.
I have a table where the date is stored as 20,130,231,220,000. And I converted it to a readable format value "20130231".
But Since no February month as 31 days am getting an Date error in HANA Data Preview output, Since a wrong value has been stored in the table.
Kindly provide me a formula to identify or to differentiate Valid dates and Invalidates.
How to check whether "20130231" this is a Invalid date. Kindly help me on this ASAP, so that i will create a calculated column for this date validity check.