Report--1.3 for the fiscal date. Automatically calculates beginning and end dates based on user selection date

3. Automatically calculates beginning and end dates based on user-selected dates Fill in the control source at the Start date text box: =dateadd ("M",-1, CDate ([year] & "-" & [Month] & "-26")) The function you just learned is used, this is a nested expression, CDate ([year] & "-" & [Month] & "-26") represents the 26th of the user's selected date, and the entire expression represents the 26th of the one months before the user's selected date. The "year" and "month" here are added [] to indicate that they are controls. Fill in the control source at the End Date text box: =cdate ([Year] & "-" & [Month] & "-25") 25th that represents the date selected by the user. This is the effect of the form running, and the start and end dates are updated as the years and months change.