Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Expression:
=if(Resolved > [Due Date],date([Due Date]),0)
can any one check whats the Problem in this Expression.
using this Expression i am getting the same dates also of the two fields. but i want only bigger dates.
INFO: I have converted the time-stamp [Due Date] into Date
i assume you haven't transformed the timestamp to a date, you just formatted it using date() function.
In your script, use
Date(Floor(TIMESTAMPFIELD)) as DATEFIELD
While creating date field in the script, try using floor() like:
Date(floor(Resolved)) as Resolved
Then you would get single date in the list box for each date unlike you are having now.