Solved

Conditional Formatting GI

  • 17 June 2022
  • 6 replies
  • 69 views

Userlevel 1
Badge

I have a IFF here that is working for formatting the cell in yellow

=IIf( [POOrder.Status] = 'N', IIf( [POLine.PromisedDate] < Today(), 'yellow40', 'default'), 'default')

 

What I want is to highlight the cells that are +14 days from today.

Like you can in a filter @Today+14

 

Thanks

 

icon

Best answer by Naveen Boga 17 June 2022, 13:27

View original

6 replies

Userlevel 7
Badge +12

Hi @john25  You wanted to highlight the cells where the PromisedDate > 14 days from today?

Userlevel 1
Badge

Naveen, that is correct.

Userlevel 7
Badge +8

Hi @john25 

Try using DateDiff function. Here is thread that has an example.

Hope this helps. 
Regards,

 

Userlevel 7
Badge +12

Hi @john25  You can use below formula. I just verified it and working as expected.

Formula

=IIf( [POOrder.Status] = 'N', IIf( DateDiff( 'd', [POLine.PromisedDate] , Today())  < 14 , 'yellow40', 'default'), 'default')

 

 

Userlevel 1
Badge

@Naveen Boga  could you please also include to highlight the dates less then @today?

Thanks

John

 

Userlevel 7
Badge +12

Hi @john25  Try like below it may work (I have not tested it)

 

=IIf( [POOrder.Status] = 'N', IIf(   [POLine.PromisedDate]  < Today() , 'yellow40', 'default'), 'default')

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved