Counting quarters between two date variables

[Imran Khan]

Hi,

I am struggling to calculate the number of quarters between two date variables. I want to generate a new variable that could report the number of quarters between the two dates.

clear
input int ArrangementNumber str35 Recipient float(Approvaldate ProgramReviewDate)
117 "Algeria" 12248 12842
117 "Algeria" 12248 12842
117 "Algeria" 12248 12508
117 "Algeria" 12248 12508
 77 "Algeria" 12565 12676
 77 "Algeria" 12565 12918
 77 "Algeria" 12565 12918
 77 "Algeria" 12565 12918
 77 "Algeria" 12565 12676
 77 "Algeria" 12565 12676
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13879
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13879
 84 "Algeria" 12925 13879
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13148
 84 "Algeria" 12925 13514
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13514
 84 "Algeria" 12925 13879
 84 "Algeria" 12925 13148
 84 "Algeria" 12925     .
 84 "Algeria" 12925 13148
 84 "Algeria" 12925 13514
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13300
 84 "Algeria" 12925 14030
 84 "Algeria" 12925 13148
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13665
 84 "Algeria" 12925 13514
623 "Angola"  18224 18520
623 "Angola"  18224 18793
623 "Angola"  18224 18793
623 "Angola"  18224 18336
623 "Angola"  18224 18336
623 "Angola"  18224 18336
623 "Angola"  18224 18428
623 "Angola"  18224 18520
623 "Angola"  18224 18793
623 "Angola"  18224 18336
623 "Angola"  18224 18520
623 "Angola"  18224 18611
623 "Angola"  18224 18336
623 "Angola"  18224 18976
623 "Angola"  18224 18793
623 "Angola"  18224 18611
623 "Angola"  18224 18976
623 "Angola"  18224 18793
623 "Angola"  18224 18428
623 "Angola"  18224 18520
623 "Angola"  18224 18428
623 "Angola"  18224 18793
623 "Angola"  18224 18428
623 "Angola"  18224 18611
623 "Angola"  18224 18611
623 "Angola"  18224 18336
 73 "Benin"   12078 12204
 73 "Benin"   12078 12204
 73 "Benin"   12078 12204
106 "Benin"   12078 12691
106 "Benin"   12078 12691
106 "Benin"   12078 12691
107 "Benin"   12078 13117
107 "Benin"   12078 13117
201 "Benin"   13389 13604
201 "Benin"   13389 13604
286 "Benin"   13389 14578
286 "Benin"   13389 14394
286 "Benin"   13389 14578
286 "Benin"   13389 14394
end
format %tdDD/NN/CCYY Approvaldate
format %tdDD/NN/CCYY ProgramReviewDate

I look forward to your guidance.

Best regards,
Imran Khan.

[Nick Cox]

Thanks for the clear data example. The code you want is just

gen nq = qofd(ProgramR) - qofd(Approval)

if I understand you correctly. You need to convert daily dates to quarterly and then subtract. All you need to know there is at help datetime

[Imran Khan]

Many thanks Nick!
This is exactly what I needed.

Best regards,
Imran Khan.