Add Plus & Minus Date Range.

[cap.zadi]

Dear Sir

Kindly advise for the below format, how to extend the the date range from the given date on form to extract results from a query.



[Forms]![QcertDetails].[PDate]

Requirement: The data shall be displayed in range of 10 days plus and minus from "PDate".

[jwhite]

Google the DateAdd() function and "date range".

[cap.zadi]

Dear

Thanks for your feedback. Bye the way, I knew that. If could understand the given examples then shall not ask here.

Anyhow, thanks for your valuable time.

Regards

[Micron]

Try
BETWEEN DateAdd("d", -10, [Forms]![QcertDetails].[PDate]) AND DateAdd("d", 10, [Forms]![QcertDetails].[PDate])

[RuralGuy]

Perhaps if you showed us what you've tried already, we could assist.

[CJ_London]

If could understand the given examples

what examples? what don't you understand?

[cap.zadi]

Hi

This works.

Thanks for the help.