You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Has anyone figured out how to compare two date fields on a single contact?

Received Response
31
Views
2
Comments
in Eloqua 2 comments

Use case 1: I'm trying to create a segment/filter that returns contacts who have a datefield1 that is greater/less/equal to datefield2.

Use case 2: I'd like to create a filter that returns contacts where contact.datefield1 is greater/less/equal than linked CDO.datefield1.

I tried some out-of-box stuff.. no luck.. the closest i got was contact.datefield1 dynamically greater than today and contact.datefield2 dynamically less than today…. if both dates are on the same day (but different times) then I don't get my use case :(. I guess it could work for "equal", but that's still not exact time.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!