Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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!