日期時間處理

取得本月的第一天

let l_date= MDY(MONTH(TODAY),1,YEAR(TODAY))

---

取得本月的最後一天

let l_date=MDY(MONTH(TODAY),1,YEAR(TODAY))  + (  1 UNITS MONTH )
let l_date=l_date - 1

---

取得上月的第一天

let l_date=MDY(MONTH(TODAY),1,YEAR(TODAY)) - ( 1 UNITS MONTH )

---

取得上月的最後一天

let l_date= MDY(MONTH(TODAY),1,YEAR(TODAY)) - 1

========================================================================
2011/03/23 update for Genero ....哇哈哈哈...