I'd like to get a week of the current date as data.

sql=sql & "where (per like '%"&emp_name&"%') and (std_dt between '2018-10-21' and '2018-10-26') "

You are about to get data for the last week of the current date.

I put it in that way with "and." ㅜ<

std_dt between "2018-10-21" and "2018-10-26" I don't know how to give it in the category!! ㅜ....

I'd like to get the data with the current date of +7 Help me

1.I modified it nowten thousand (std_dt between "?start_date", "YYYYMMDD", and "?end_date", "YYYYMMDD") Like this I put it in, but do I need to put +7 in end_date? I'm afraid I'll have to pay the price limit. I don't know how to put it in.Help me