Date/Time field: Set time to 00:00:00 always

[Desmo]

Hello,

I have a Date/time field [u_kickoff_start] in the Task [ticket] table that gets populated by the last Updated [sys_updated_on] based on some conditions.

Requesting for a script to change the display in [u_kickoff_start] to show the time as 00:00:00. Additional solutions welcomed.

Thank you.

[Chaitanya Redd5]

Hi Chaquino,

You can refer to the below link where numbers of functions are provided related to date/time.

https://developer.servicenow.com/app.do#!/api_doc?v=newyork&id=r_ScopedGlideDateTimeGetTZOffset

Kindly mark my answer as Correct and helpful based on the Impact.

Regards,

Chaitanya

[Desmo · Accepted solution]

I found a solution using Flow Designer to set a field value from one table, then set a field value in another table. The flow: Date/Time field > Date field > Date/Time field The solution is easy to design and does not require any business rules or scripts.