Skip to Content
avatar image
Former Member

Timestamp to date in calculated column

Hi all,

We have following in a date field 20.141.114.070.000  and want to convert it to something like 22.04.2016 in a calculated column.

Can someone help me here?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 26, 2016 at 06:54 AM

    In a calculated column of a graphical calculation view you can use the "format" function (check docu Date Functions). Assuming your date/time information is stored in longdate format (or converted to it on the fly) an example would look like following.

    Calculated column (column VALUE contains the long date):

    Result:

    In case of a not supported format, you can always use the "component" function to extract the specific parts of the date/time column to build up your requested format.

    Regards,

    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 23, 2016 at 03:23 PM

    Are you sure 20.141.114.070.000=22.04.2016? I mean to say, if we convert said values then our output should be 22.04.2016. Need clarity.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      No it was just an example.

      It is more about how to create a output like 22.04.2016 from a timestamp that looks like 20.141.114.070.000 with a calculated column.

  • avatar image
    Former Member
    Sep 26, 2016 at 06:47 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded