Solved

VisibleExpr for Date in Report Designer

  • 19 January 2024
  • 2 replies
  • 43 views
M
Rank
Userlevel 4
Badge

We have a report that we want to highlight the last billed date if it is six months or older, but I’m having trouble getting the correct coding to make it happen. 

I know that I’ll have to have two overlapping fields, one visible for the highlighted dates, and one visible for the non-highlighted dates. 

For the highlighted dates, everything I’ve read has lead me to believe that 

=[ContractBillingSchedule.LastDate]>=Today(),'m',-6 should work, but it doesn’t. I’ve tried adding additional parenthesis, apostrophes, etc., but always get the same error:
 

Syntax error in the expression. Context: TextBox 'textBox53' property 'VisibleExpr'

 

Any ideas? I’m sure it’s probably something simple that I’m missing. 

icon

Best answer by Yulia Steinberg 19 January 2024, 18:51

View original

2 replies

Y
Rank
Userlevel 2
Badge

Hi,

Try using DateAdd( date, interval, number ) function:

 

=[ContractBillingSchedule.LastDate] >= DateAdd( Today(), 'm', -6)

M
Rank
Userlevel 4
Badge

@yulias18 Thank you, that worked! 

Reply


Terms & ConditionsCookie settings
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 — 2024  Acumatica, Inc. All rights reserved