Question

Convert Text to DateandTime

Forum|Forum|1 year ago
January 23, 2025
24 replies
0 views

Hi Team,

I have below text and I want to convert it into a Date and Time.

Example:

Text: "01/07/2025 12:00:35 PM"

Date and Time: 01/07/2025 12:00:35 PM or 01/07/2025 12:00:35 PM GMT+00:00

stefanhelzle0001

Did you try the todatetime() function?

https://docs.appian.com/suite/help/24.4/fnc_conversion_todatetime.html

Here are more functions in Appian: https://docs.appian.com/suite/help/24.4/Appian_Functions.html

sameeru0003Author

Not able to get the desired output if i use only todatetime(). I think need to use more functions to get the exact value i am specifying.

stefanhelzle0001

What is the desired output? Are you missing the seconds?

jayaprakashr0001

Text: "01/07/2025 12:00:35 PM"

Can you specify in which format it is dd/mm/yyyy or mm/dd/yyyy if it is mm/dd/yyyy then you can use the datetime() function else you need to split and convert to datetimeformat.

sameeru0003Author

Its mm/dd/yyyy

jayaprakashr0001

Can you share the code as you are using split() it returns a list. So for the datetime field try indexing the output of the split data.

Sign up

Login with SSO

Login to the community

Login with SSO