B bazzat Jan 16, 2008 #1 how do i get access to count days starting with a date, then adding a number of days and giving me a due date.
how do i get access to count days starting with a date, then adding a number of days and giving me a due date.
G George Jan 16, 2008 #2 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" ÎγγÏαψε:
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" ÎγγÏαψε:
J John W. Vinson Jan 16, 2008 #4 how do i get access to count days starting with a date, then adding a number of days and giving me a due date. Click to expand... 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]
how do i get access to count days starting with a date, then adding a number of days and giving me a due date. Click to expand... 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]
