Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 22nd September 2017, 06: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

Hi
How to get The first day of the month and The last day of the month?
Reply With Quote
  #2  
Old 22nd September 2017, 07: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
Sponsored Links
  #3  
Old 6th October 2017, 23:52
rahul ingale rahul ingale is offline
Member
 
Join Date: May 2011
Location: Hyderabad
Posts: 33
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.
__________________
IRL
Reply With Quote
Reply


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 01:42.


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