Re: Comparing Dates

It all starts with the data.

I have no idea what data you are actually storing in your tables, so it
could be tough offering specific "how to's" ...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Public" <Public@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF924BF5-5244-43F7-92D5-0D9EC96FC1B5@xxxxxxxxxxxxxxxx
Hi,

I want to compare two dates. I have a date field from a table and I want
to
compare it with another date (say DateB). The problem is that DateB's day
and
month parts are constant but the year part is coming from a form. How can
I
write the complete DateB. I have tried writing something like
1/1/[Forms]!etc. and it did not accept that.

Any ideas?

Regards



.

Relevant Pages

  • Re: Comparing Dates
    ... John Spencer ... Access MVP 2002-2005, 2007-2008 ... I have a date field from a table and I want to compare it with another date (say DateB). ...
    (microsoft.public.access.queries)
  • Re: Macro Coding calculating if one date entry is before another date entry
    ... Date variables are just doubles in drag, so you can use ordinary arithmetic ... to compare them -- ... If DateA < DateB then ... ...
    (microsoft.public.word.vba.general)
  • Re: Detecting Brute-Force and Dictionary attacks
    ... usually modern systems doesn't compare the password you ... write with the saved password; instead, they compare an hash of your ... an idea which might be usefull to detect brute force attempt. ... The reason for storing the previous passwords is that ...
    (Focus-Linux)
  • Checking a date/number between two others
    ... I often have a need to compare a date with two other dates and see ... whether dateA is between dateB and dateC. ...
    (microsoft.public.excel.misc)
  • Re: Strange basic problem with comparision of two varialbes defined as double
    ... What alternative is there to compare two values of this sort? ... seen this kind of problem were in I am storing a value defined as double in ... the access database field which is again defined as double with 2 decimal ... My application does need to compare a lot of values for accounting purposes. ...
    (microsoft.public.vstudio.development)