Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Wouter,
Now() will return a Timestamp with decimal places, while I assume your DATUM values are integer values in numerical representation. Consider using Today() instead.
Then, do the Date formatting also in your variable definition:
LET vYesterday = Date(Today(1)-1);
Thus your DATUM set element modifier looks like
DATUM = {$(vYesterday) }
Hi Swuehl,
thank you, I didn't know the difference between Now() and Today().
I have changed the formula's, but without success. Any other ideas?
First check, that your DATUM values are integer values, too, e.g. by creating a list box with field DATUM and an additional expression num(DATUM). Should only show integer values like 40933.
Then check that your DATUM field values use also the standard date format, which is used in formatting Date(today(1)).
Check that your DATUM field has a value for today..
Lastly, try enclosing your variable values in single quotes:
DATUM = {'$(vYesterday) '}