I have an application that records run training by folks. There are users in other parts of the world and they are having trouble entering training because of the time zone issue. The service does not allow them to enter training for a future date but it is basing that on something like this:
If CDate(TrngDate) > Date Then "You can't enter training for a future date."
How can this be resolved?