View Single Post
Old 22nd September 2017, 06:47
IndoTech's Avatar
IndoTech IndoTech is offline
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
with functions you can get day, month, year
then replace day = 01
and to 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 will return firat day of next month just -1 from the date will give you last day of previous month.
Reply With Quote