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.
You don't need pick and/or match. Try something like this:
If your Data field doesn't contain dates but strings you may need something like:
Unfortunately, I can't quite get it to work. I have attached some dummy data.
See attached qvw.
Many thanks Gysbert,
Its working perfectly, much appreciated
Retrieving data ...