- 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 01:58 PM
That worked, evidently I messed up with DD instead of dd. Thanks so much for the help!