Calculate Quarterly dates from a Start date
What is the correct way to calculate the next quarterly dates form a given start date
dateadd("q", 1 , StartDate)
using the above it calculates what month the next quarter is in but not the actual date
if my startdate 15/01/2005 (<= dd/mm/yyyy british date)
i would like to calculate the next quartly date from the 15th of jan
would i have to used days 365 then / by 4 to split the year into 4 then use that result to just add days to the startdate to get the next date ?
i.e. quarter (1 year) = 91.25 days
|