[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Calculating the first and last date in a quarter

  • Thread starter Thread starter Niall Morgan
  • Start date Start date
Status
Not open for further replies.
N

Niall Morgan

Guest
If i was doing it in excel i would use this for the first date =DATE(YEAR(A2),FLOOR(MONTH(A2)-1,3)+1,1) and for the last date i would use =DATE(YEAR(A2),((INT((MONTH(A2)-1)/3)+1)*3)+1,1)-1

Continue reading...
 
Status
Not open for further replies.
Back
Top