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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 5th October 2017, 13:48
amator's Avatar
amator amator is offline
Junior Member
 
Join Date: Aug 2016
Posts: 20
amator is on a distinguished road
Baan: Baan 4 - DB: SQl Server 2012 - OS: Windows 8
Exclamation Conditional Formatting (ERP Ln 10.4) compare to the current date
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: None/Unknown

Hi guys,

I'm trying to create a conditional formatting in the Inventory 360 (Item -
Lots Inventory) .

For example

IF Lot date < Lot date + "CURRENT DATE" Then
......
Endif

I'm trying to get the Current date but I don't know how to declare it in Conditional Formatting.

Is there a way to get the current date in conditional formatting?

Thanks in advance guys,
Amator
Reply With Quote
  #2  
Old 5th October 2017, 13:53
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
in 4c4 I would use date.num(), but with ln using UTC dates you might want to try searching for the board for UTC date formats.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 6th October 2017, 22:35
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
utc.num() for getting current utc date.
__________________
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
compare utc date and date without time IndoTech Tools Development 1 23rd May 2017 11:15
How to compare current date and date field ? jeffersyuan Tools Development 5 9th April 2006 14:07
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 10:50
how to get current date ? learner Tools Development 8 13th January 2003 23:04


All times are GMT +2. The time now is 05:47.


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