I am confused here, I have a non-stored field being populated by a saved search that pulls the date/time from the system notes when an SO goes into Pending Billing status. The search is working just fine, but when I run a workflow to move the value from the non-stored field to a stored field, set up exactly the same way as the non-stored field, except for it being a stored field, I get an error. I am not sure why it will not allow me to move a Date/Time value from the non-stored to the stored field. It lets me select the stored field in the Workflow

might be reading/converting as text? date/time fields are funky

How do I fix that? Do I have to do it as a formula and convert the date/time to something else, it is being used in a workbook in NetSuite to calculate the time it takes for our warehouse to ship something. So we need both the date and time.

Hey Todd - I've ran into this before. In my situation, it had to do with the search returning seconds precision and the stored field did not accept seconds. I was able to replicate the behavior by editing the non-stored field: once I clicked into it and then out of it again, it dropped the seconds off of the value. I ended up using the Formula field in the workflow action to reformat my date/time

I have tried that, but nothing works, if I use to date, it removes the time, which we need to calculate the delta between SO, create and SO shipped

Could you try resolving it further upstream by changing your summary search? If you use a formula text field, you can control the formatting upfront:

TO_Char(your_date}, 'MM/DD/YYYY HH:MI:SS AM')