Hi
I have form which contains the fields of SchYear (Combo Box), StartDate & EndDate fields.
I want to auto fill up the startDate & EndDate by selecting the year from ComboBox.
If select 2018
StartDate: 01/01/2018
EndDate: 31/12/2018
I have the below code for defaults values as for current year but how to guide the date fields according to the combo box?
DateSerial(Year(Date()),1,1)
DateSerial(Year(Date()),12,31)