Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   How to get The first day of the month and The last day of the month? (http://www.baanboard.com/baanboard/showthread.php?t=70455)

qiangyao 22nd September 2017 05:09

How to get The first day of the month and The last day of the month?
 
Hi
How to get The first day of the month and The last day of the month?

IndoTech 22nd September 2017 06:47

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.

rahul ingale 6th October 2017 22:52

adjust code for if you are finding last date of December as adding 1 to December will give wrong results.


All times are GMT +2. The time now is 04:15.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com