Buckmaster
New member
- Local time
- Today, 02:33
- Joined
- Apr 29, 2010
- Messages
- 6
I have a form (frmTransferInAging) where the user inputs a value for business days (eg 10) into txtBusDays. The value is used by a query to determine 10 business days from today - For example, if 10 was entered today I want to calculate 10 business days before today - how do I calculate this date?
I am currently using the following criteria in the query which returns calendar days:
<=(Date()-([Forms]![frmTransferInAging]![txtBusDays]))
I believe I can create a function to call from the query?
I am currently using the following criteria in the query which returns calendar days:
<=(Date()-([Forms]![frmTransferInAging]![txtBusDays]))
I believe I can create a function to call from the query?