Convert Text field to date

  • Thread starter Thread starter Ashby
  • Start date Start date
A

Ashby

In the field row of the query qrid type:

CDate([YourField])

To Add 1 to the date:

CDate([YourField])+1
 
Hi Ashby,

thanks for the reply!
It doesn't work. I get #error in the output.

Any other suggestion?

Appreciate your help!
-Alice
-----Original Message-----
In the field row of the query qrid type:

CDate([YourField])

To Add 1 to the date:

CDate([YourField])+1
-----Original Message-----
I have a text field with date stored in yyyymmdd format
I want to add 1 day to this, when I try to
use DATEADD('D',1,<FIELDNAME>) it doesn't do anything
and query return #error for the output.
I want to be able to add 1 day to the text field and then
compare with another date which is again a text field.
My question is how can I concert a text field into
date field only in the query not in table definition.

Thank you,
Alice
.
Click to expand...
.
Click to expand...
 
Back
Top