• Home
 · 
• Miscellaneous
 · 
• Set datepicker to first day or last day of the current month. This code works on any regional syste

Set datepicker to first day or last day of the current month. This code works on any regional syste

Set datepicker to first day or last day of the current month. This code works on any regional system date setting.

API Declarations


'Then use the code to initialize their values.



Rate Set datepicker to first day or last day of the current month. This code works on any regional syste

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

'Set datePick1 to the first day of the current month
datePick1.Value = DateAdd("d", -(Day(Now) - 1), Now)

'Set datePick2 to the last day of the current month
datePick2.Value = DateAdd("d", -(Day(DateAdd("m", 1, Now))), _
                          DateAdd("m", 1, Now))