Query with dates and number of days

[samcooldude1430]

Dear Experts,

I want to create a in which user would input the start date and the number of days user wants the data. What should be the excel query for the same?

I used WHERE ((([Union_part 2].period_start_time)=[Enter start date:] And ([Union_part 2].period_start_time)=[Enter number of days:])

But it is giving me error!

Please help. Thanks

 

[apr pillai]

You must make some changes to your query definition. Add the following Parameter definition line at the beginning:

PARAMETERS enter_StartDt DateTime, enterDays Long;

then make changes to the WHERE clause as follows:

WHERE (([Union_part 2].period_start_time >=[enter_StartDt]) And ([Union_part 2].period_start_time)<([enter_StartDt]+[enterDays]))