Date query

[Philangr8]

I'm trying to do a select query to automatic display the date with the next day's date from the actual date using the below formula:



>= DateAdd("d",-1,#9/30/2009#) or <=Date()-1


but it doesn't work. It still shows the date as 9/30/2009 instead of 10/1/2009. What am I doing wrong?

Thanks

[Brian62]

Try something like this:

Next Day: Format(DateAdd("d",1,[Audit Date]),"mm/dd/yy")
you can change Next day to what ever column name you want.

[Philangr8]

What is audit date?

[Philangr8]

Do I put in the whole statement that's:

Next Day: Format(DateAdd("d",1,[Audit Date]),"mm/dd/yy")

but replace Next day with the column name that I have?

[Brian62]

yes, change to your column name.

[Philangr8]

I dont know what I'm doing wrong but it doesn't work. Will you post the exact formula on here for me?

UPDATE_DATE is the date that I'm trying to change. The value is 9/30/2009. I'm trying to have it change automatically to 10/1/2009.

Thanks

[Brian62]

Next Day: Format(DateAdd("d",1,[Update_Date]),"mm/dd/yy")

Enter this statement in the field row in your query by itself in a new column. You can change Next day to whatever column name you want.

[Philangr8]

Got it.

Thanks