Adding days to date field

[Guest]

Hello out there,
I would like to subtract 90 days from a date that is a prompt field to see
if there are claims within that three month range. I have tried Expr1:[Date
Prompt]-90 but this doesn't work.
thx,mary

 

[Guest]

Hi Mary

Try this - it will display a date 90 days beofre your date field. Not sure
if this is what you're looking for though. If not then please give a bit
more details.

=DateAdd("d", -90, [DateField])

 

[Guest]

Sorry just re-read your question (ooops)

Use this as the criteria

Between DateAdd("d",-90,([PromptDate])) And ([PromptDate])

Hope this helps - Good look -