I have two date fields "MonthEndDate" and "date" I want a condition to satisfy that if date is less than 15 then take previous month end date and if date is more than 15 then take current month end date. Eg-
|MonthEndDate | date | ResultDate |
6/30/1999 | 7/2/1999 | 6/30/1999
10/31/1999 | 11/1/1999 | 10/31/1999
5/31/2009 | 5/28/2009 | 5/31/2009
Aucun commentaire:
Enregistrer un commentaire