Convert Text field to date

[Ashby]

In the field row of the query qrid type:

CDate([YourField])

To Add 1 to the date:

CDate([YourField])+1

 

[Alice]

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
.

.