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

Billy_u — Sat, 16 Nov 2024 00:40:39 GMT

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

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

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