Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 66

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 22nd September 2017, 05:09
qiangyao qiangyao is offline
Junior Member
Join Date: Apr 2007
Posts: 28
qiangyao is on a distinguished road
Baan: ln61 fp3 - DB: oracle - OS: windows2003 server
How to get The first day of the month and The last day of the month?
Baan: Other/Unknown
C/S: None/Unknown

How to get The first day of the month and The last day of the month?
Reply With Quote
Sponsored Links
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
Old 6th October 2017, 22:52
rahul ingale rahul ingale is offline
Join Date: May 2011
Location: Mumbai
Posts: 59
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
adjust code for if you are finding last date of December as adding 1 to December will give wrong results.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +2. The time now is 11:46.

©2001-2018 - -