How to compare DATE using greater/Smaller(>) sign

I have to compare Date fileld of a particular object with another Date field.

Like Start_date__c >= End_Date__c ( will it work in Apex? if not then waht is the syntax)

November 2, 2009
·
Answer
·
Like
0
·
Follow
0

JimRae
That should work fine. Are you getting an error? If so, post your code, and the exact error message.

November 2, 2009
·
Like
0
·
Dislike
0

arunk
Hi,

That should work ...

Reagrds,
Arun

November 2, 2009
·
Like
0
·
Dislike
0

Superfell
If you're trying to do this in SOQL, then you cannot compare one field to another in SOQL.

November 3, 2009
·
Like
0
·
Dislike
0

arunk
Hi,

SimonF is correct. You cannot compare two fields, we can only compare a field with literal values. One work around is to use a formula field that has subtracted value the two dates, and then compare this to 0 in the query. ... ...
Or you will need two queries, one to get a field and then you can use it in the next query ...

Regards,
Arun

November 4, 2009
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

How to compare DATE using greater/Smaller(>) sign

You need to sign in to do that.