View Single Post
  #2  
Old 22nd September 2017, 06:47
IndoTech's Avatar
IndoTech IndoTech is offline
Member
 
Join Date: Jul 2005
Posts: 72
IndoTech is on a distinguished road
Baan: Baan IV, Infor LN 10.4 - DB: SQL-Server2000, Oracle, Informix - OS: Windows NT, Unix
Hi
with num.to.date functions you can get day, month, year
then replace day = 01
and to date.to.num() you pass day, month and year you will get first day of the month.

for last day add 1 to the month and pass to date.to.num() will return firat day of next month just -1 from the date will give you last day of previous month.
Reply With Quote