I have a date field in the data base as 80039583. How can we get this converted into the date field in Qlikview?
This date refers to 16.04.1996. Did anyone come across such issue??
Appreciate your effort for the response.
Use following formula:
(99999999 - Date_field) as Date_field
You will get date in 'YYYYMMDD' format. Convert it in suitable format by using Date() function.
Thanks neha. It worked for me quite well.
I guess this was some logic in the SAP data base.
Retrieving data ...