No replies to this topic

[reachpradeep]

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