Display Text in Text Object depending on today() function?

[#1]

I have an excel table loaded into qlikview with two columns, one contain a task description and the other dates. What expression would I need to display the task description in the text object if the date listed in the table matches the current date?

The closest if have gotten to this working is with this expression:

=only({<Baseline_Start={'MM/DD/YYYY')}> }Task_Name)

but I would like for it to use the today() function for the date instead of manually entering the date string so it will update on its own.

Any suggestions? Thanks.

[MarcoWedel · Accepted solution]

=only({<Baseline_Start={"$(=Today())"}>} Task_Name)

or maybe you have to adjust the format to your settings like

=only({<Baseline_Start={"$(=Date(Today(),'MM/DD/YYYY'))"}>} Task_Name)

hope this helps

regards

Marco

[maxgro]

maybe with a $

only({<Baseline_Start={"$(=Today())"}>} Task_Name)

[MarcoWedel]

already noticed it was missing, thanks

regards

Marco

[#5]

Thanks Marco.  The first solution worked perfectly.