Skip to main content
Solved

Can I format the date to DDMMYY using CREATED_TIME()

  • April 15, 2020
  • 2 replies
  • 24 views
M
Forum|alt.badge.img

Can I format the date to DDMMYY using CREATED_TIME()

The default format is 2015-11-11T22:18:17, how can I change it to DDMMYY (no spacing between dates)

Thanks

Best answer by Eric_Petersen

You will create a new formula field with the following formula:

DATETIME_FORMAT(CREATED_TIME(),'DDMMYY')

    C

    2 replies

    E
    Forum|alt.badge.img+11
    • Eric_Petersen
    • Inspiring
    • Answer
    • April 15, 2020

    You will create a new formula field with the following formula:

    DATETIME_FORMAT(CREATED_TIME(),'DDMMYY')

    M
    M
    Forum|alt.badge.img
    • Momin_Bannani
    • Author
    • New Participant
    • April 15, 2020

    You will create a new formula field with the following formula:

    DATETIME_FORMAT(CREATED_TIME(),'DDMMYY')


    Eric you rock :boom: :metal: it worked perfectly

    Terms & ConditionsAccessibility statement