Question on Flow Designer transform string to date function.

Tate Roth
Tera Contributor

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?

1 ACCEPTED SOLUTION

Try the following, it worked for me:

 

EEE MMM dd HH:mm:ss 'PST' yyyy
e.g.

JamesChun_0-1709760700094.png

 

 

View solution in original post

5 REPLIES 5

That worked, evidently I messed up with DD instead of dd.  Thanks so much for the help!