Share
Explore
Select a period
April 1-30, 2021
(MyDateRangeTest)

Prev Month
This Month Up To Today
Last 180 Days
Today
Last 7 days
Yesterday



Yesterday=>
SetControlValue(MyDateRangeTest,
List(
Today()-1,
// in this case we put in the list, both the same day, as we are looking for only one day
Today()-1
)
)

Today=>
SetControlValue(MyDateRangeTest,
List(
Today(),
// in this case we put in the list, both the same day, as we are looking for only one day
Today()
)
)


Last 7 days=>
SetControlValue(MyDateRangeTest,
List(
Today()-7,
// listening the period: Today() - 7 days till today
Today()
))

This month up to today=>
SetControlValue(MyDateRangeTest,
List(
EndOfMonth(Today(), -1) + 1,
// Today() we are in April, the month before(-1) is March and the end of March is the 31st + 1 day = 1st of April
Today()
)
)
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.