Format datediff to show date only in function field

kim-lindgren
Kilo Sage

I know this has been asked several times on the forum, but I am going to try again in case something has changed.

 

When using datediff in a function field, there is a need to show only days, not hours and minutes. Seemingly the function field cannot deal with variables or ordinary javascript methods - so is there nothing we can do? It really is a basic requirement.

 

It would also be nice to have a condition in the function field, so that it can simply show "Expired" if the datediff returns 0 or less.

 

Calculated fields are calculated every time a row is read so they are not an option.

 

Regards,

Kim

0 REPLIES 0