If Date = Today ()

[eugeniyaromanov]

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.

[sunny_talwar]

I try this:

if(date(DateFired, 'DD.MM.YYYY') = Today(), '----',  DateFired)

Where you trying this? Would you be able to share a sample?

[ahaahaaha]

May be

Only ({<DateFired={"=DateFired<>Today()"}>}DateFired)

[eugeniyaromanov]

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.

[Anonymous]

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,' ')

[eugeniyaromanov]

Hi!

Won't work...

Still show today date when shouldn't be.

[eugeniyaromanov]

Again it shows today date when shouldn't be

[ahaahaaha]

In attached file

[eugeniyaromanov]

Example

hope it works well.

[sunny_talwar]

Are you looking for one of the two?