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.
- Polars YYYY week into a date
- Why is my value returned as a pl.Float32 and not a pl.Date?
- Compare Polars DataFrames That Have a Polars Date Colums
- How to convert a FILETIME to an excel date
- Carbon.php The separation symbol could not be found Data missing
- How to return ISO date format in PHP for MongoDB?
- Calculate the start-date and name of a quarter from a given date
- JavaScript for getting the previous Monday
- Extract separated date from a text
- Date Field Not Outputting Correct Format on URL
- What does CCYYMMDD date format mean?
- Merge Date & Time
- Trying to calculate time between subsequent appointments in SAS
- Convert java.util.Date to String
- Is java.sql.Timestamp timezone specific?
- Trying to figure out why my GoogleSheets Date formula is not working
- How to convert date in to yyyy-MM-dd Format?
- Check if one date is between two dates
- How to retrieve the current day of the week?
- GWT get build date
- PHP date() with timezone?
- Comparing text fields that contain dates in Google Sheets
- Carbon and PHP DateTime parse single letters as dates, but not multi-character strings
- Detect daylight saving time in bash
- java.util.Date vs java.sql.Date
- Find all month names between two given date in java
- vba return first row number in column that has todays date or nearest date after today
- Iterate over all last-day-of-the-month dates in a year
- How to set the current date in the gnuplot title
- How can I validate a date in Python 3.x?