I need to find documentation or example code for how to set a "Time Of Day" field using SS 2.x. I have already tried using the format function and that failed, and I have tried using several different formats to fulfil the goal, with no luck. Any examples, or documentation you guys can point me in the direction of would be awesome.

Try something like this using N/format module.

nFormat.parse({
  value: new Date(yourDate),
  type: nFormat.Type.DATE,
});

Regards!

If you are setting the value to a Date and Time field you need to use nFormat.Type.DATETIME;

I haven't tried using Type.DATE or Type.DATETIME yet because I thought the field only took TIMEOFDAY. I'll give that a go, thanks

Pretty sure the time of day data type is actually a date time and it displays only the time bit in the UI,

Yeah that worked for me in the console as well, it was weird that when I get into SS 2.0 and tried using the same strings it choked

the console doesn't care if there is a space or not, hard to say what is common; I never work with time of day fields, the only reason I have one in my instance is because someone else had the same problem

usually the basic answer to these questions is that you use a Date with setValue and a string with setText

^

@Sandii and @battk - if this were reddit I might give you gold, date worked! Thanks!

beware time zones

good point, I may need to ask some questions about how the time is being passed in

if you have a choice, get iso-8601 formatted in utc like

2021-01-19T22:22:50.951Z

.toISOString() should work off of the date for that right? or do I want a utc specific one?

it sounds like you are getting a string as external input

@battk I am now seeing an error saying: "You have entered an Invalid Field Value org.mozilla.javascript.NativeDate@f9ce9b9 for the following field: {myField}" Do I need to use format.format to set the value as a date?

I personally always prefer to use setText and use the string version. But in general, yeah format.format should be able to fix your problem.

@Sandii can you tell me how I could use set text to set the TimeOfDay? is it as simple as: myRecord.setText({fieldId: 'myField', value: "01:05 AM" }); I'm not sure that's even the correct formatting for that value, but something like that?

Yeah that seemed to work in my limited testing

okay I can give that a try, and I'll update this thread afterward, thanks

i will double down on my warning about date formats

Same, I almost exclusively use moment to deal with dates unless its something super super simple.