Date Formating 1

[tjisaacs]

I have a table containing "collection date" this is a text format. I want to create a query that calculates the collection date plus 1 year, 2 year and 5 year. This is what I have but get results "Error" in data.

[collection date]+365

I tried a DateValue but still get Error

 

[binky]

tjisaacs,

Have you tried the Value function?

Value([collection date])+365

Value will return the numeric value of a text string.

HTH
Binky :
><>

 

[acct98]

Consider changing the field that contains the Date to Date Time. Then your formular should work.

 

[thornmastr]

This gets interesting. For example, using the immediate debugger:
?date + 365
9/16/2003
? &quot;09/16/2003 + 365
09/16/2002 + 365
?#09/16/2002# + 365
9/16/2003


using the above you can see adding some number to a text string will give you the tet string concatonated with the number added, but if you mask the string date as a date, it will work just fine.

Use the following code

dim newdate as variant
dim thisdate as date
thisdate = [collection date]
newdate = thisdate + 365
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com