Convert date to date/time value

Leonel Sandroni · ‎01-21-2025

Hi there!

I'm trying to accomplish with a client requirement. They need to move the date of due date field in demands to the due date field in enhancement. Field specifications are as follows:

Due Date Demands:

table: dmn_demand
type: date

Due Date in enhancements:

table: task
type: date/time

In order to move this value from demand to enhancement I have modified the script that create enhancements from demands with this statement:

It seems to work correctly but there is a little problem that you can check below:

Demand:

Enhancements

You can see how enhancemetns takes the previous day at 17:00 to the one I put in demands

Is there anyway to adjust this in order to get the same dates in both fields?

thanks!!!

Ankur Bawiskar · ‎01-21-2025

@Leonel Sandroni

I already informed in my 1st response it's because of the mismatch in field type

2 ways

1) create a new date field and set the value

OR

2) let the date value be populated in date/time with 00:00:00 in GMT and discuss with your customer

I won't recommend updating the OOB field on enhancement table.

Hiding of time in due date is not recommended and would be possible with client script.

Even if it's feasible it would require DOM manipulation which is not best practice.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎01-21-2025

@Leonel Sandroni

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader