3 Replies Latest reply: May 7, 2009 4:57 PM by Ion Morosanu RSS

    transform UNIX date format to ASCII /Windows format

    Ion Morosanu

      Hello,

      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?

      Thanks in advance,

      Regards,

      John