- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 08:31 AM
I am creating a flow to do a JDBC load from KACE and for some dates it uses a string format that looks like this;
Wed Mar 06 07:53:22 PST 2024
I have most everything else working, but I'm having an issue getting it to enter the date into a date field on the cmdb_ci_computer table. The field is Date/Time and I am trying a String to Date transform on the data pill with the following custom format;
"EEE MMM DD HH:mm:ss 'CST' yyyy"
It does not seem to be working and in the execution, it looks like it's just trying to pass the string in with no modification. Any tips or suggestions?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 01:31 PM
Try the following, it worked for me:
EEE MMM dd HH:mm:ss 'PST' yyyy
e.g.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 08:57 AM
Hi @Tate Roth ,
Please refer to below thread:
https://www.servicenow.com/community/developer-forum/date-conversion-problems/m-p/1698988
If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!
Thanks & Regards,
Sumanth Meda
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 11:59 AM
Hey @Tate Roth,
Looks correct to me, but can you try removing the "" in the format?
i.e. EEE MMM DD HH:mm:ss 'CST' yyyy
Also, can you share how the date field is displayed in the target record?
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 01:10 PM
I had already tried that and I just did it again along with commenting out the EEE section by replacing it with 'Wed' instead so it looks like this.
'Wed' MMM DD HH:mm:ss 'CST' yyyy
I get no entry in the field at all, since it doesn't match it leaves it empty or if it's an existing record, it leaves the old value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 01:31 PM
Try the following, it worked for me:
EEE MMM dd HH:mm:ss 'PST' yyyy
e.g.