Convert String to Date and Time using GlideDateTime Function in SNOW
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2022 10:10 PM
I Have a requirement to auto create standard changes in bulk via excel sheet which contains the data by using flow designer.
To auto populate planned start date and time and planned end date and time (in 12 hours format including AM and PM) on change record via flow designer, please help me how to auto populate.
Here I am reading the data from the sheet from "sys_attachment" table and storing the data as a string value.
Similarly, I am storing the planned start date and time and planned end date and time in string values.
I have to convert the string value to date and time value and populate it on the change record along with AM and PM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2022 11:16 PM
Hi, depending on your data forma you may be able to map the fields directly, as some conversions are supported without you needing to utilize GlideDateTime - showing AM\PM is probabaly a local setting and not an import function as date\time fields are stored at db level as unix\epoc and referenced to UTC. Otherwise you can instantiate GlideDateTime for non standard date\time conversion and use string manipulation\conversion for unsupported formats but you may need to allow for time-zone reference (actual or assumed).
Unfortunately your post is missing details\examples of your timestamp format, so difficult to be more specific.
