VishalMistry
26th April 2019, 14:54
Hello Everyone,

I was just playing with LN 10.4 test environment and exploring Conditional Formatting.

Can anybody guide me how can we compare the value of field with current date?

e.g. I want to list all purchase order lines for which planned delivery date is < current date. (Planned receipts past due date)

Any help with suitable example will be highly appreciated.

Vishal

DStroud
29th April 2019, 12:51
If you review the Conditional Formatting Help you should find the information bellow:

 You cannot compare a date field or a UTC field to a fixed date. You must always compare to a relative date. You can enter, for example:
 >=-0 or >=+0 (later than now)
The + or - is mandatory. If you specify a 0 without a + or -, the 0 is considered as an absolute value. In that case the filter checks whether the field is empty.
 +1 (tomorrow)
 -7 (1 week ago)
 -365 (1 year ago)