Another text date question

[jneirinckx]

I have a form that has a calculated query field that calculates a next date by using the DateAdd function which works fine but because it ends up as being text data type I can't query on a date range. I then have to report on a range of dates but because it is a text data type doesn't work.
I have searched high and low and tried some solutions but with no success.

Any ideas would be appreciated.
Thanks
Jerry

 

[boblarson]

I have a form that has a calculated query field that calculates a next date by using the DateAdd function which works fine but because it ends up as being text data type I can't query on a date range. I then have to report on a range of dates but because it is a text data type doesn't work.
I have searched high and low and tried some solutions but with no success.

Any ideas would be appreciated.
Thanks
Jerry

Why does it end up being a text data type? DateAdd should return a date. How are you getting it to be TEXT?

 

[jneirinckx]

Thanks for your reply.
Not sure why it comes out as text as the DateAdd gets the input from three fields. NewDate: DateAdd([interval],[term],[PledgeDate]). When I enter some criteria it shows as ie: 1/1/2009 rather then #1/1/2009#.

Any ideas.
Thanks
Jerry

 

[Husan]

convert text to date using cdate(string)

 

[gemma-the-husky]

1/1/2009 rather then #1/1/2009#.

dates won't SHOW with the # chars, they just need them to work with queries/sql

but your date should look like

01/01/2009 (even if you enter 1/1/09 access will format it properly)

if you are seeing
1/1/2009 then it is not a date, and you do have a problem

 

[jneirinckx]

Found a work around. Thanks for all your help.
Jerry