Comparing two date fields

[leech10]

Hi

I need a query to compare 2 dates and they cannot be the same. basically they cannot be equal.  Below is working but only when days/months/years differs. When seconds, minutes or hours it is not working. Report displays records whereas it should not. Encoded query works the same. 

grPrjT.addQuery('end_date','NSAMEAS', 'u_latest_baseline_date')

Could you please advise what query should I use in this case

Regards

Piotr

[SumanthDosapati]

Why are you adding "N" before SameAs?

Is your field name "work_startN" ?

Regards,
Sumanth

[leech10]

Hi

No, as it should be different, Not same as. so with NSAMEAS. I need to have record displayed where those 2 fields are different.

I thought NSAMEAS is comparing any value, is there any different comparison option?

[SumanthDosapati]

Yes. If it is different, then NSAMEAS should be working. It will only check if the hour hour is not same in between those two date fields.