Re: Macro Coding calculating if one date entry is before another date entry
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date variables are just doubles in drag, so you can use ordinary arithmetic
to compare them --
If DateA < DateB then ...
"macroapa" <macroapa@xxxxxxxxxxxxx> wrote in message
news:1155718717.732721.43730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have two date fields within a User Form.
I require code that will amend produce two different sets of wording
dependant on whether Date A is before or after Date B.
ie If Date A is before Date B then Type "xxxxxx"
If Date A is after Date B then Type "yyyyy"
.
Relevant Pages
- 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: Specifying a criteria when the field can be null
... This would mean you can return rows within the range, anytime after the ... (where dateA and dateB are text fields in a parameter form, ... I was considering the use of an IIF statement with IsNull: ...
(microsoft.public.access.queries) - Re: Specifying a criteria when the field can be null
... criterion should be FALSE. ... (where dateA and dateB are text fields in a parameter form, ... I was considering the use of an IIF statement with IsNull: ...
(microsoft.public.access.queries) - Re: Hybrid/electric car vs plane
... >> what the L/D of a car is. ... > The drag coefficient of a car is typically ~0.3. ... An airplane's power requirement must include the weight as a factor, ... > does this compare to a car? ...
(sci.energy) - Re: Mottram
... Mottram 100m or so from the finish. ... Mottram is all the more impressive when you compare the relatively massive ... There are two aspects to drag: form drag, ...
(rec.running) |
|
