Web Development

Ask something
Question Locked

Access Date Query

0 helpful
5 replies

by Member 26724489

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi
I am trying to calculate the number of days an item has been outstanding from the received date using todays date.

I would like to use the calculated query for a report which I will create.

I have used the DateDiff function but instead of simply calculating the Outstanding Days for all rows I get a parameter query prompt which I do not want.

I am new to access and hope I have explained what I am trying to do.
This is what I currently have
DateDiff("d",[DATE RECEIVED],Now())

Hope I have explained what I need to do.
Thanks
Carl

5 replies

by bizzo

Carl,

Not too hot on access myself, but i think the Now() function returns more than just the date, it returns the time as well, try using Date(), it should return just the date part.

Good luck.

Bizzo

by gearybish

DaysWorked:DateDiff("d",[DATE RECEIVED],Now()) works just fine if you put it in the query design in a blank field.

by aaron.dewberry

Hi Carl.

You can use

expr: Date()-[Date Received]

This will calculate the number of days.

Aaron

This discussion is closed to new replies.