I need to do some comparisons in Access 2010. I have a column where I store time(15:00; 14:45 ....)
I need to put some IF statement in an Expression Builder (I use Expression Builder coz it is easy for me)
example that works:
=IIf([time_from]>=TimeValue("08:00"));"true result";"not true")
I also need to put another IF:
=IIf([time_from]0<=TimeValue("00:00"));"true result";"not true")
I need to compare this time with 00:00, with midnight... but it gives me error when I enter 00:00 if I enter 23:59, than it is ok... kind of.... but it looks funny that I have to type 23:59...
is there a way around?
thanks
Aucun commentaire:
Enregistrer un commentaire