Date Formula (Criteria)

[Noah114]

Is there a way that I can create a formula in access where all I need to do is enter in a end date, and the start date will automatically be generated by end date minus 45 days. I currently use

Between [StartDate] And DateAdd("s",-1,CDate(Int(CDbl(DateAdd('d',1,[EndDate])))))

which works excellent.

 

[PHV]

Between ([EndDate]-45) And [EndDate]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Noah114]

Hi,

I tried however get a circular error