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
Discussion posts and replies are publicly visible
date and time is part of a text and we need to extract date and time part and return in the same format as date and time data type
I asked that exact question already.
If the todatetime() function does not fit your needs, you will have to parse that string yourself using split().
its eliminating the seconds part from time and date time is not in a format mm/dd/yyyy hh:mm:ss AM/PM
Using this pattern, you can create your own date parsing expression.