get the cursor's selection value

[#1]

Hello every body

I have a cursor object and im selecting dates by expression, my problem is that the other fields are comparing with today's date not the selection date , so how do i get the value of the selection to compare with instead of today's date ?

Best Regards

[#2]

can you post the expersion used or the sample app for the same ...

[#3]

OK mr Nagaraj,

=Num(if (Num(Month([Date CA]))=Num(Month(Today())) and Num(year([Date CA]))=Num(year(Today())) and  Num(day([Date CA]))<=Num(day(today()))  ,([Date CA])))

Regards

[ashwanin]

You need to modify the expression.

here it is = today() in your expression,

Change it to the Field name of Your Selection Date field.

[#5 · Accepted solution]

In addition to the change mentioned by Ashwani Kumar - you don't have to split the date into Year/Month/Day. Date is internally represented as a number - you can compare whole date. In your case you probably have to use Floor() to ignore time portion of the date if exists

Lukasz