Hi,
I have a date time field called LH_TIME_IN.
I want to create a field next to this that is a datetime field with the same date as LH_TIME_IN but i want the time to be midnight (00:00:00:000)
Can anybody help
ive tried (LH_TIME_IN + '00:00:00:000') but this gives me the same time as LH_TIME_IN