Does anyone know how you can add a one year to a date using a query ?
R Rick Brandt Sep 17, 2003 #2 Mike said: Does anyone know how you can add a one year to a date using a query ? Click to expand... NextYear: DateAdd("yyyy", 1,[DateField]) or NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField]))
Mike said: Does anyone know how you can add a one year to a date using a query ? Click to expand... NextYear: DateAdd("yyyy", 1,[DateField]) or NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField]))
M Mike Sep 18, 2003 #3 Thank You Rick Brandt said: Mike said: Does anyone know how you can add a one year to a date using a query ? Click to expand... NextYear: DateAdd("yyyy", 1,[DateField]) or NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField])) Click to expand...
Thank You Rick Brandt said: Mike said: Does anyone know how you can add a one year to a date using a query ? Click to expand... NextYear: DateAdd("yyyy", 1,[DateField]) or NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField])) Click to expand...
