Date format

Hi abhishek.j,

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

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!

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???

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

Thanks, somehow I'd missed the documentation for that one before.  I just did some experimenting with it and I'm actually deeply saddened to notice that its "millisecond" command doesn't actually work for milliseconds - it only returns hundredths, rounded-down