Hi guys I have a problem with setting a date. I am defining two starting dates and then trying to calculate an ending date automatically.
I first define my two starting dates (dd/mm/yyyy Australian format):
dim startDate01 as date = "1/07/2004"
dim startDate02 as date = "1/08/2004"
then I want an ending date for 'StartDate01' - this has to be '30/07/2004'
so I do the following:
dim endDate01 as date = DateAdd("d", -1, startDate02)
and the result I get is:
So the day and month calculation is correct but why is my year now incremented by 5 years?