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

    Convert Time Stamp



      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