Is their a certain way I need to be wording the visible conditions when comparing dates? The documentation for Report Designer is absolutely awful with nothing about coding structure in Visible Conditions. This is what I’ve been trying to get working: tns:DUE_DATE >= vldtdate:currentDateTime()
Nothing works and Report Designer will just fail to preview a layout so often when trying out conditions.
+14Hi
Seems like your syntax fails mainly due to type mismatch. Try using below:
date(tns:DUE_DATE) >= date(currentDateTime())
Hi
Seems like your syntax fails mainly due to type mismatch. Try using below:
date(tns:DUE_DATE) >= date(currentDateTime())
That doesn’t work, when I used that the report would fail to load a preview. The only way I’ve gotten it to work was to add a custom field that would give a 1, 0, -1 depending on the comparison between the two and have the visible condition use that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.