Is there a way to check date dynamically in eloqua?
Context: I am using Microsoft Dynamics (CRM) and Eloqua to send email campaigns. I have a date field in CRM that I want to check against in Eloqua for a specific campaign. This campaign needs to check to see if the date field is <= today's date + 90 days. I am using the campaign UI in Eloqua, not doing anything programmatically at this point.
I have tried using the Compare Custom Object Fields decision in Eloqua by finding the date field, setting the comparator to
dynamically on or before, and I want to make the compared valueToday + 90 days. I'm not sure how to accomplish this in this type of Decision object because the only options I have to compare the date field to areYesterday,Today, orTomorrow. See image below:
I have also tried to use the Compare Date Decision object, but there is no dynamic comparison, just hard-coded date options.
The last thing I tried was a Wait step, but that only waits a hard-coded number of days rather than checking dynamically.
Has anyone run into this issue or know of a solution to this problem?
We were able to find an Eloqua Date App to download that adds a Date Decision step to the program builder which allowed us more flexibility with comparing dates in a custom range.
- How can I "pretty print" a Duration in Java?
- Current time formatting with Javascript
- How do I get the difference between two Dates in JavaScript?
- Create a column that assigns a date column to current month, next month, two months, keeping the year in mind. Using SQL in Toad for Oracle
- validate the credit card expiry date using java?
- R Iteratively modify values based on previous row if a condition is met
- How can I display the date in a CanvasJs chart in the x axix
- Get week of year in JavaScript like in PHP
- most accurate time type in java?
- Why Joda DateTime gives different result than Java Date?
- Error when scraping data on selection of date
- Calculate the date yesterday in JavaScript
- Getting the TimeZoneIDs for a Time Zone
- Wrong Date returning
- How to get all week dates for given date java
- How to get the YEAR for week of year for a date?
- Get the Month from a date string
- Java day of the week from string
- Add/Subtract months/years to date in dart?
- Creating a new Date object or using setter methods of javascript Date()
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Why dec 31 2010 returns 1 as week of year?
- Calculate weeknumber from a date value
- How to auto insert Current DATE in SQL with Java / Hibernate
- JavaScript date objects UK dates
- reverse date javascript from yyyy/mm/dd to dd/mm/yyyy
- Joda Time get date from Year + WeekOfYear + DayOfWeek
- Count the number of inclusive dates covered by a date period
- convert mysql timestamp into actual date and time?
- How to find week of the month