#0:00# == #12:00:00 AM#

[phpatrick]

hi, the default value of my time field is 0:00.
However in module code access is transfering 0:00 to 12:00:00 AM.

Is this correct ? For validation I check the content of the field, if the value is > then the default value 0:00 , the field can't be updated.

 

[Golom]

Yes ... it's correct. 00.00 is midnight which is also 12:00 AM. If you format it as a military (i.e. 24-hour) time then it will appear as "00.00"

? Format(timevalue("12:00 AM"), "hh:nn")
00:00

 

[SkipVought]

Hi,

FYI, the Time VALUE for midnight is ZERO. Time values are in units of DAYS and are expressed in fractions of a day and are part of DATE.

Midnight TODAY is 38936.0
Noon TODAY is 38936.5

Can be DISPLAYED in a number of FORMATS.



Skip,

_[red][/red]