RE: What is expression for tomorrow's date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "cdielman" <cdielman@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Aug 2005 14:47:08 -0700

Fixing the data type to date/time corrected the problem. Thanks very much
for your help.

"cdielman" wrote:

> I have an input variable that represents a StartDate. When I try to look at
> StartDate+1, the query gags. I need to look at data for each of the 4 days
> following the StartDate. How do I represent this expression?
.

References:
- What is expression for tomorrow's date
  - From: cdielman

Prev by Date: Re: Multi-Level BOM (Bill of Materials)
Next by Date: need a query to look for specific num of bytes in a field
Previous by thread: Re: What is expression for tomorrow's date
Next by thread: Multiple Records By Date
Index(es):
- Date
- Thread

Relevant Pages

Re: access database and "date" field
... startdate & "#", con, adOpenStatic, adLockReadOnly ... data type is used. ... presentantion without formatting symbols, ... startdate", con, adOpenStatic, adLockReadOnly ...
(microsoft.public.vb.controls)
Help needed with Data type Mismatch
... I have a problem with data type mismatch. ... SELECT Dinq(TargetDate([SFStartDate]),Date()) AS Dinq ... If StartDate < 0 Then 'Evaluate Argument ...
(microsoft.public.access.queries)
Please help with datatype mismatch
... I have a problem with data type mismatch. ... SELECT Dinq(TargetDate([SFStartDate]),Date()) AS Dinq ... If StartDate < 0 Then 'Evaluate Argument ...
(microsoft.public.access.queries)
Data Type
... I use the attached to return a value in an append query. ... get it to work is if I set the Data Type in the table the data is being ...
(microsoft.public.access.queries)
RE: What is expression for tomorrows date
... In God We Trust - Everything Else We Test ... "cdielman" wrote: ... > I have an input variable that represents a StartDate. ...
(microsoft.public.access.queries)