mardi 27 janvier 2015

midnight hour in timevalue in access

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