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.

[eugeniyaromanov]

Thank you for a try, but where is Name 2 and Name 3?

[Anonymous]

This seems to work if(Datefired<>date(today(),'DD.MM.YYYY'),Datefired,' ') wrapping the today() function in the date format DD.MM.YYYY to match the date fired. Let me know if this doesn't solve your problem.

Kindest regards

Brian

[eugeniyaromanov]

Eh.. no...

I should look like

Name	DH	DF	Exp
Name 1	2017-01-01	2017-01-31	30
Name 2	2017-02-01	----	62
Name 3	2017-02-02	----	61
Name 4	2017-02-03	2017-02-04	1
Name 5	2017-02-04	2017-04-03	58

[eugeniyaromanov]

Please, see the attachment I put, may be it'll help.

[eugeniyaromanov]

Hi!

No, it shows today when shouldn't...

Please, see my attachment i put, may be it can help.

[sunny_talwar · Accepted solution]

Check the attached

[eugeniyaromanov]

Perfect!

Thanks a lot!

Saved my day

[Anonymous]

Hi

The below is the result I get is this what you are looking for?

I just used a pivot table with name and datehired as dimensions and the following expressions:

Datefired expression- if(DateFired<>date(today(),'DD.MM.YYYY'),DateFired,' ')

Experience expression - =sum(Exp)

I apologise if I've misunderstood your requirement.

[eugeniyaromanov]

Good morning!

thanks for a try, but I tried yours expression and it still shows a date when it shouldn't ...

Anyway, Sunny's expression works perfect!