1 Reply Latest reply on Jan 8, 2014 1:18 AM by Aman Lamba

    Adding Timestamp to an existing date field

    Aman Lamba

      How to add Timestamp to an existing date field?

      Lets say we have a date as: 2013-11-21

      and we have hour of the timestamp as: 10

      The hour ranges from 1 to 24

      Is it possible to create a date time field which looks like

       

      2013-11-21-10 or 2013-11-21 10:00:00

        • 1. Re: Adding Timestamp to an existing date field
          Aman Lamba

          FYI.. I've tried to create them as such

           

          DATETIME(STR(YEAR([EVENT_DATE_PST_NKEY]))+"-"+

          STR(MONTH([EVENT_DATE_PST_NKEY]))+"-"+

          STR(DAY([EVENT_DATE_PST_NKEY]))+" "+

          STR([EVENT_HOUR_PST_SKEY]))+":00:00")

           

           

          DATETIME(STR([EVENT_DATE_PST_NKEY])+" "+STR([EVENT_HOUR_PST_SKEY])+":00:00")

           

          The calculation shows no error but when I apply it in the worksheet, it gives error as

           

          "Invalid Timestamp"