If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
90 days and the first of the month
I'm trying to figure out hoe to calculate 90 days from hire and the first
of the month Example: HiredDate Insurance activated 1/3/2010 4/1/2010 That is 90 days and the following 1st of the month Exception to the Rule: 1/1/2010 3/1/2010 If hired on the first its just HiredDate +90 All I came up with for my query is INSsurance: DateAdd("m",3,[DateHired]-Day([DateHired])+1) Any assistance wiuld greatly be appreciated Thanks G -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|