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.