DateAdd question

[scossar]

Well first of all I'm new at this so any help would be greatly apreciated.

What I am trying to do is set a date in a field based on a date entered in a previous field on the same form.

The second date I want is 5 months and 28 days after the first date but I can't figure out the combination of DateAdd arguments to do this (tried +, AND etc)

Is there any way to do this. The argument has to go into an IIF argument aswell because it is dependent on a value selected in a combo box also.

Hope someone can help

scossar

 

[Jack Cowley]

DateAdd("d",28,(DateAdd("m",5,[YourDate])))

[This message has been edited by Jack Cowley (edited 04-15-2002).]

 

[scossar]

thanks for the help

working great now

thanks again