B
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.
of days and giving me a due date.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
George
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" ÎγγÏαψε:
Try to use the DateAdd
e.g. DateAdd("m",2,[YourDateFiled]), which will show a date 2 months later
than your date.
GeorgeC
Ο χÏήστης "bazzat" ÎγγÏαψε:
G
Guest
Try count("dd-mm-aaaa") and it answer the number of day between now.
J
John W. Vinson
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]