Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
need help for date diffrence
- Thread starter sonadi
- Start date
IanWaterman
Programmer
Is this for selecting data or a formula
It will be something like
postingdate >= dateadd("d", -30, paymentdate)
This assumes postingdate is before payment date. If later cahnge to 30 (ie no minus)
Ian
It will be something like
postingdate >= dateadd("d", -30, paymentdate)
This assumes postingdate is before payment date. If later cahnge to 30 (ie no minus)
Ian
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question