8 Replies Latest reply: May 24, 2016 6:32 PM by Marco Wedel RSS

    Making timestamp adds days to date

    Dafnis X

      Hi,

       

      based on other discussions, I used the following expression to create a timestamp

      based on a date and an hour from different fields.

       

      Timestamp(RsvLineCreateDate+ [RsvLine Create Hour], 'DD/MM/YY hh:mm')

       

      But the final date in the timestamp is always 2 days later then the basis date.

      for example:

      date: 07/11/2011

      time:07:51:00

       

      final timestamp: 09/11/2011 07:51

       

      Any idea why it happens?

       

      Thanks!