transform UNIX date format to ASCII /Windows format
I have a data source where tha date and time is under unix format (timstamp: number of seconds since 1970/01/01 00:00:000).
I need to transform this in ASCII timestamp/ Windows Standard. I cannot see a QlikView Function to do this. I can use DADEDIFF when with SQL but I still need to have the result also for csv data sources.
Is anyone aware of a QlikView built-in function? Or maybe a VBScript to calculate?
By the way, I don't recommend implementing this formula in VBScript function (even though it looks cool) - it will slow things down a lot. Once you nail the exact syntax of the formula, either copy it everywhere you need, or use $() - extensions to encapsulate the logic.