date conversion 8 digits issue?

[subin6600]

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

[#2 · Accepted solution]

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

[subin6600]

Thanks neha. It worked for me quite well.

I guess this was some logic in the SAP data base.