9 Replies Latest reply: Jan 19, 2015 2:53 PM by Marco Wedel RSS

    Num(Date)

    Gyanaranjan Tripathy


      Hi,

      I need the date field values as num.

       

      Some of the records are coming as numbers but some are coming as date format.

      I'm using the below command to make them all alike.

       

      If(E_TIMESTAMP='YYYYMMDD',NUM(Floor(Date(E_TIMESTAMP))),E_TIMESTAMP) as E_TIMESTAMP

       

       

      But that don't help. i used LEFT(E_TIMESTAMP),8) too.but that's not sorting my prob either.

       

      Any suggestions plz?

       

      Thanks in advance.