Date Expression

[#1]

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

[swuehl]

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

[tresB]

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.