Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Billy_u
Creator
Creator

Date, Date-calendar, replace, if, range of date, getfieldselection in a if


Good morning, I have a date field valued with '31/12/9999' that would indicate the still active validity of that data, also I have a calendar where to select a date whose max date = today, so I would like to replace the '31/12/9999' of the date field with the selection of the calendar date, otherwise I can not view the records at 31/12/9999, I pended to do:

=replace(DATE_FIELD ,'31/12/9999', getfieldselections(Data_calendar)), but is not valuing getfieldselection, or

=if(DATE_FIELD = date('31/12/9999','DD/MM/YYYY'), dates(GetFieldSelections(Data_calendar),'DD/MM/YYYY'), dates(DATE_FIELD , 'DD/MM/YYYY')) and does not work.

so I tried to put the variable instead of getfieldselections, but it doesn't work, does not value it, I hope I have explained myself, thanks to everyone for the availability, do you have suggestions?

 

thx Billy

Labels (4)
0 Replies