I've got a table :
Today() is needed, so I can't change it.
It stores in qvd file thеn like:
In a file i need to display 4 fields:
Name | DataHired | DataFired | Work Experience
And I have a problem with DataFired, I want it to be shown only if the date is not today.
I try this:
if(date(DateFired, 'DD.MM.YYYY') = Today(), '----', DateFired)
but it won't work...
In another two text fields I put :
1. = Today()
2. = DataFired
just to verify data and they are the same.
Can get it to work by hard coding the date in the expression which makes me assume it is something to do with the date format.