Forum Discussion
PatSpillane
Jun 17, 2021Copper Contributor
Remove Date data from date time field
How do you remove date data from a date/time field so that all you have is the time data?
- Jun 17, 2021
PatSpillane Like this:
dbcooperfoxman
Mar 24, 2025Copper Contributor
remove date from time with am/pm
3/25/25 7:00 pm ==> 7:00 pm
to allow me to subtract 7:00 pm - 6:00 pm ==> 1
- SergeiBaklanMar 25, 2025Diamond Contributor
= (7:00 pm - 6:00 pm)*24 with applying number format