alkrm
Registered User.
- Local time
- Tomorrow, 00:18
- Joined
- Aug 13, 2003
- Messages
- 39
i have a query that compare between two working days.
in order to compare between the current date and previous working date am using this in the criteria at the previous working date field :" [current date]-1"
the problem comes with the Holidays and the week ends.
where "[current date]-1" is wrong in this case. Cause there is no fields or these (dates,records) "Holidays or Weekends" are not exist in the table.
is there is any function that let u select the Previous Record of the [ current date ]to be inserted in the criteria of the previous date.?
in order to compare between the current date and previous working date am using this in the criteria at the previous working date field :" [current date]-1"
the problem comes with the Holidays and the week ends.
where "[current date]-1" is wrong in this case. Cause there is no fields or these (dates,records) "Holidays or Weekends" are not exist in the table.
is there is any function that let u select the Previous Record of the [ current date ]to be inserted in the criteria of the previous date.?
