Skip to main content
abhishekj0003
New Participant
Jul 8, 2021 10:20 AM UTC
Question

Date format

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

    5 replies

    selvakumark
    Participating Frequently
    Jul 8, 2021 12:34 PM UTC

    Hi [mention:469dbb8fff614d95ac4443a8b1825457:e9ed411860ed4f2ba0265705b8793d05],

    If your question is just to format the date-time value into that specific text format for displaying, then refer to the below link:

    docs.appian.com/.../fnc_text_text.html

    harshits1832
    New Participant
    Mar 21, 2023 8:20 AM UTC

    hi there,

    when i am writing datetext() function in which we have to specify the format in format if i write "YYYY/MM/DD" then it returns a date like 2023/02/4563 the date is not possible and if i write a format like this : "YYYY/MM/dd" here dd is in lower case then it returns the correct date in the output.... wht is it so???

    stefanhelzle0001
    Brainy
    Mar 21, 2023 9:02 AM UTC

    This is how the syntax is defined. Check the documentation: docs.appian.com/.../fnc_scripting_datetext.html

    madhusudans0001
    Participating Frequently
    Jul 8, 2021 12:36 PM UTC

    Hi Abhishek, you can use the following snippet:

    datetext(now(), "MMM dd, yyyy h:m a")

    For more information, check datetext() function. Hope it helps!