Decode EXEC.EX_DATE column in DataFlux repository

[bmedalen]

Does anybody have a query to decode the EXEC.EX_DATE column in the DataFlux repository?  It kinda looks like a Unix date integer, but it is in decimal format so I am not sure how to decode it.

Thanks,

Brett

[sdoorneveld]

took me half a day to find out, but here is the result:

attrib new_date format=datetime20.;

new_date = intnx('dtyear',ex_date*3600*24,-60,'S');