Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bazzat - 16 Jan 2008 09:01 GMT

how do i get access to count days starting with a date, then adding a number
of days and giving me a due date.

Reply to this Message

George - 16 Jan 2008 10:34 GMT

Dear,

Try to use the DateAdd

e.g. DateAdd("m",2,[YourDateFiled]), which will show a date 2 months later
than your date.

GeorgeC

Ο χρήστης "bazzat" έγγραψε:

> how do i get access to count days starting with a date, then adding a number
> of days and giving me a due date.

Reply to this Message

Vincent - 16 Jan 2008 11:02 GMT

Try count("dd-mm-aaaa") and it answer the number of day between now.

> how do i get access to count days starting with a date, then adding a
> number
> of days and giving me a due date.

Reply to this Message

John W. Vinson - 16 Jan 2008 18:07 GMT

>how do i get access to count days starting with a date, then adding a number
>of days and giving me a due date.

Put a calculated field in a Query by typing

DueDate: DateAdd("d", [numberofdays], [startingdate])

Instead of [numberofdays] you can just type a number - 14 for 14 days etc.

John W. Vinson [MVP]

Reply to this Message