Pick and Match Function (Lookup)

[#1]

Hi All,

I have a table which has say two columns Date & Day number (this has no relation to normal day numbers). How can I write an expression say in a text box that tells me what day number today is using pick and match functions or any other alternative.

Thank you

H

[Gysbert_Wassenaar]

You don't need pick and/or match. Try something like this:

=only({<Date={'$(=today())'}>} DayNumber)

If your Data field doesn't contain dates but strings you may need something like:

=only({<Date={'$(=date(today(),'MM/DD/YYYY'))'}>} DayNumber)

[#3]

Thanks Gysbert,

Unfortunately, I can't quite get it to work. I have attached some dummy data.

Thanks

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#5]

Many thanks Gysbert,

Its working perfectly, much appreciated

H