Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Br
Subin
Hi,
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.
Regards,
Neha
Hi,
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.
Regards,
Neha
Thanks neha. It worked for me quite well.
I guess this was some logic in the SAP data base.