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

Desmo
Mega Guru

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.

 

1 ACCEPTED SOLUTION

Desmo
Mega Guru
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.

View solution in original post

6 REPLIES 6

sachin_namjoshi
Kilo Patron
Kilo Patron

you can set default value date time for your field.

You don't need to write script.

 

Regards,

Sachin

Hi Sachin,

Looking to have the field [u_kickoff_start] display 00 00 00 when the Update field is copied into it. For example, if Updated [sys_updated_on] is 2020-02-15 13:45:15, field [u_kickoff_start] displays 2020-02-15 00:00:00.

 

Thanks.

Hi there,

When should this date be copied? onChange? On save? Client Side? Server Side?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Hi Mark,

Server side on save. 

Thank you,
Charlie