value in a new field based on date on another field

[dudumoscona]

Hi,

I have a field that shows the date and in case the date is today or yesterday i would like to put in a new field sentnce "The date is today or yesterday based on that...."

how could i do it?

[sunny_talwar]

May be this

LOAD Date,
If(Match(Date, Today(), Today()-1), 'The date is today or yesterday based on that', 'N/A') as NewField
FROM ...;

[dudumoscona]

If(Match(PURTRANSDATECDP, Today(), Today()-1), 'Waiting for interface run') as ReasonCDP,

didnt work 😞

[sunny_talwar]

Would you be able to share a list box with PURTRANSDATECDP field? Also, could you try this

If(Match(Floor(PURTRANSDATECDP), Today(), Today()-1), 'Waiting for interface run') as ReasonCDP,

This to make sure that we remove time component if PURTRANSDATECDP is a timestamp

[dudumoscona]

still give no value (attached pic)

[sunny_talwar]

Can you try this

If(Match(Floor(PURTRANSDATECDP), Today(1), Today(1)-1), 'Waiting for interface run') as ReasonCDP,

[dudumoscona]

thank you very much for your help, still doesnt work , i think it doesnt work maybe becouse my date field is calculated , im adding the calculation of the field .

same result "-" value

[sunny_talwar · Accepted solution]

That might be it... try this

If(Match(Floor(MakeDate(1988) + PURTRANSDATECDP/1440), Today(1), Today(1)-1), 'Waiting for interface run') as ReasonCDP,

[dudumoscona]

it working, in case i want to add another condetion if field is bigger than other?
exmaple in my pic 🙂

you are awsome!

[dudumoscona]

sorry wrong picture, add new one