7 Replies Latest reply: Mar 19, 2014 7:10 AM by Pierre de Calan RSS

    Convert Time Stamp

      Hi,

       

      Could someone kindly assist me with a time stamp conversion problem I have. I have a field (Received Date) which has a time stamp, and an example is : 13.3.2014  13:28:16 . I would like to convert this to a date and have been trying the following:

       

      Date(Floor(TimeStamp#([Received Date],'DD.MM.YYYY hh:mm:ss')),'DD.MM.YYYY') as [Received Date],

       

      For some strange reason it is not converting the time stamp and is returning values of "-" in the Received Date field.

       

      Help please .

       

       

      Thank you Herbiec 09