1 Reply Latest reply on Oct 2, 2013 3:46 AM by 5304419582

    Formatting a Calculated Date Time Field

    KennethHibberd

      Title

      Formatting a Calculated Date Time Field

      Post

           Hello all,

            

           I am getting my rear end kicked here trying to format an output of something that I am sure is simple.  It is likely that a function of script would be easier.  That I do not know.

           I need to output a value into a field using calculation.  That value is formatted as so:

           DayHourMinSecMonthYear  So right now is 02 October 2013 08:02:45 hours.  I want the output to be as  020802451013 so all output needs to be two digits.  I have a good calc created but the format is not two digits.

            

           Day(Get(CurrentDate)) & Hour(Get(CurrentTime)) & Minute(Get(CurrentTime)) & Seconds(Get(CurrentTime)) & Month(Get(CurrentDate)) & Year(Get(CurrentDate))

           This outputs 2802451013  making it confusing.  My output must always be the same number of digits every time.

            

           What am I missing here?