Hello,
I have 2 date and time fields in a table field1 : starttime and field2 : stoptime.
I have a record where field2 (stoptime) with date 12/03/2021 23:15:40 (hh:mm:ss). Now i want to write in field1 of this record the value 12/03/2021 00:00:00 to calculate afterwards the difference from midnight to stoptime. So i only have this stoptime to create this midnight value from. Someone any idee how to do this?
Thanks in advance,
Bieke
I have 2 date and time fields in a table field1 : starttime and field2 : stoptime.
I have a record where field2 (stoptime) with date 12/03/2021 23:15:40 (hh:mm:ss). Now i want to write in field1 of this record the value 12/03/2021 00:00:00 to calculate afterwards the difference from midnight to stoptime. So i only have this stoptime to create this midnight value from. Someone any idee how to do this?
Thanks in advance,
Bieke