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?
