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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 5th October 2017, 13:48
amator's Avatar
amator amator is offline
Junior Member
Join Date: Aug 2016
Posts: 26
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

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,
Reply With Quote
Old 5th October 2017, 13:53
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,109
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.

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
Old 6th October 2017, 22:35
rahul ingale rahul ingale is offline
Join Date: May 2011
Location: Mumbai
Posts: 57
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
utc.num() for getting current utc date.
Reply With Quote
Old 8th November 2017, 04:09
amator's Avatar
amator amator is offline
Junior Member
Join Date: Aug 2016
Posts: 26
amator is on a distinguished road
Baan: Baan 4 - DB: SQl Server 2012 - OS: Windows 8
Thumbs up Problem solved!

Hi mark_h and rahul ingale,

Sorry for the late reply. mark_h, I've tried using the utc.num() in the LN 10.4 and it displays what I've needed. Thanks a lot

Also thanks rahul ingale, I used your sample date.num and I've searched it in Baanboard and thanks to that I used it in my another problem when creating a customize session.

This is a part of code/query looks like in my customize session.

Code:, ayr, amh, ady, ahr, ame, asd), cyr, cmh, cdy, chr, cme, csd)
age =, amh, ady) -, cmh, cdy)
Thanks again guys and also to Baanboard,
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

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 18:07.

©2001-2018 - -