Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello again!
Another problem.
I've got a table :
Name | DateHired | DateFired |
---|---|---|
Name 1 | 01.01.2017 | 31.01.2017 |
Name 2 | 01.02.2017 | Today() |
Name 3 | 02.02.2017 | Today() |
Today() is needed, so I can't change it.
It stores in qvd file thеn like:
Name | DateHired | DateFired |
---|---|---|
Name 1 | 01.01.2017 | 31.01.2017 |
Name 2 | 01.02.2017 | 04.04.2017 |
Name 3 | 02.02.2017 | 04.04.2017 |
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.
Check the attached
I try this:
if(date(DateFired, 'DD.MM.YYYY') = Today(), '----', DateFired)
Where you trying this? Would you be able to share a sample?
May be
Only ({<DateFired={"=DateFired<>Today()"}>}DateFired)
Hi Sunny!
I't kind a hard because it's all in Russian
But I will make a smaller file with inline load so you will be able to see it, give me 5-10 min.
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.
if(Datefired<>'04.04.2017',datefired,' ')
Hi!
Won't work...
Still show today date when shouldn't be.
Again it shows today date when shouldn't be
In attached file
Example
hope it works well.
Are you looking for one of the two?