By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,695 Members | 1,346 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,695 IT Pros & Developers. It's quick & easy.

Problem with LEAVE of a datetime field

P: n/a

I have a datetime field, when I leave this field I am trying to call some
validation on the date enered, namely that the date cant be ahead of today.

My validation checks the date entered against todays date. If the user
types the following in:


then this fails. If she includes the extra zero:

07/09/2005, its fine.

I have debugged and stepped into the Leave trigger and for some reason at
the top of the leave trigger the date is not set correctly the first time it
runs, but the second time it runs it is ok! Its like the Leave trigger is
firing too early for me to validte the date on as it hasnt put in the extra
zero for me the first pass through.

Any one experienced this? Is there a event that fires after leave? If you
type in 07/9/2005 then tab out, it will correct itself and show as
07/09/2005, but this doesnt seem to occur until after the LEAVE trigger has


Sep 7 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a

Be aware that the date you give can have more meanings in the different
culture settings no I assume it is the seventh of september. However am I
right when I assume that you have binded this textbox to a datatable.column
which has as type datetime?

The event to validate is of course validate, (as I assume that you mean with
trigger an event).

I see that nowhere in your text.

Sep 7 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.