Conditional Formatting using dates. . .

[mysticalypse]

I built a database on my system and my Forms work great on my system. Then I put the database on our server. Everything works as planned from my computer, but when I open the database from anyone else's computer the date dependent conditional formatting doesn't work.

The text box Controls are supposed to change color if date conditions are met. Is there a problem with the way I'm stating the date?

Field Value is less than Date()-365

It seems like my database is still getting the current date from my system instead of the server, how do I fix this?

Note: other conditional formatting works for any user (when no conditions are met) and (when Field Value has focus). . . Thanks in advance for your help!!!

 

[MarkK]

I don't know why, but when we installed Server 2003, all Access references to the "Date()" function failed, so we replaced them all with "Now()". Weird but true. "DateValue(Now())" returns just the date.

 

[mysticalypse]

Thanks Lagbolt!!!

I was starting to sweat. . . I've spent the last two weeks at work on this you can imagine my frustration, have a great weekend and thank you for posting!

 

[MarkK]

Ya, cheers.