I have a field with the datatype TIME. I need to set the time an action occurs on edit. Does anyone know the proper syntax to set the time in a formula? I tried helpcenter but the example isnt working. If I hard code the value it works, so I know my workflow logic is correct and it's my formula. cant get date.getTime() or {today} to work.

I would be starting with TO_CHAR({today} ,'HH24MISS'). Initially also populate it to a text field to see what it looks like.

That didnt seem to work after field edit. But this does for anyone interested. nlapiDateToString(new Date(), 'timeofday')