Hello I have a form which has a textbox for a start date: txtDateStart and an end date: txtDateEnd
I have been able to set the default values as follows:
txtDateStart = DateSerial(Year([Date]),Month([Date])-1,1)
txtDateEnd = DateSerial(Year(Date()),Month(Date())+1,0)
This works fine in that it gives me the start and end dates of the CURRENT month.
Can someone help me tweak the code so I am able to set it to display the start and end dates of the PREVIOUS month.
Many thanks Mark
I have been able to set the default values as follows:
txtDateStart = DateSerial(Year([Date]),Month([Date])-1,1)
txtDateEnd = DateSerial(Year(Date()),Month(Date())+1,0)
This works fine in that it gives me the start and end dates of the CURRENT month.
Can someone help me tweak the code so I am able to set it to display the start and end dates of the PREVIOUS month.
Many thanks Mark