JaimeJegonia
asked on
AutoFill Date Ranges base on selection
Dear Experts,
I Have a DropDown with the following Lists Thisweek, Lastweek, ThisMonth, LastMonth and the textboxes (Date1 & Date2).
What I want by selecting DropDown List it will also populate corresponding values as follows :
Selected: Date1 Date2
ThisWeek: Monday's Date Today' Date
ThisMonth 1st Day of this Month Today' Date
Lastweek Monday of Last week Sunday of Last week
LstMonth 1st Day of Last Month End of Last Month
Thanks
I Have a DropDown with the following Lists Thisweek, Lastweek, ThisMonth, LastMonth and the textboxes (Date1 & Date2).
What I want by selecting DropDown List it will also populate corresponding values as follows :
Selected: Date1 Date2
ThisWeek: Monday's Date Today' Date
ThisMonth 1st Day of this Month Today' Date
Lastweek Monday of Last week Sunday of Last week
LstMonth 1st Day of Last Month End of Last Month
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Victor,
Great! It needs only few tweaks to meet my requirement.
Thanks,
Jimi
Great! It needs only few tweaks to meet my requirement.
Thanks,
Jimi
ASKER
Smart gist!
ASKER
Thank for answer, I'll try it.
Jimi