Dear all,
Thank you once again, as usual i got code tips from you guys today after implementing it, this solve part of my challenges now i want to convert list of duration to duration in months
| Duration (int) | Number of Months |
| 30 | 1 month |
| 90 | 3 months |
| 60 | 2 months |
| 120 | 4 months |
the script is shown below
Select PatientId, VisitDate,drug_Type, Duration from PatientPhermacy
i want the duration to be in number of months as in the table above.
thank you all

Esakki MuthuPosted Oct 24, 2016, 9:00 AM
Abraham OlatubosunPosted Oct 25, 2016, 12:33 AM
Aakash MauryaPosted Oct 24, 2016, 8:10 AM