Kevin_Vaughn

@Jo_Pitts1 ,   Thank you so much for providing the details. This makes perfect sense. We actually have a few other fields we use as filters too, we can handle them all this way. We will be using this method.   Thanks again! Kevin  ... View more

@Jo_Pitts1 , Thank you for taking the time to respond to my post! Much appreciated.   Your option number 1 certainly has merit and in the end, this may be what we have to do. But I would prefer something like your option 2.   Regarding number 2 there is something I'm not understanding. You suggested  creating a smart campaign that looks for any of those fields changing, and then set 'finalSyncDone' with a date. But the problem is that Marketo cannot see these fields changing; the field changes are happening in SFDC and once changed the sync with Marketo stops for that person.   Thanks, Kevin ... View more

Thank you for taking the time to provide this (your check's in the mail 😉 ). I am pretty sure I would not have figured this out on my own, at least not by my deadline. Very grateful for your assistance. ... View more

Here is the raw output, 2021-03-18T10:30:00.000-05:00, which formats to March 18, 2021 10:30 AM.   And here is  a view of the person in Marketo with the two hour time difference.   ... View more

Hi Sanford,   Thank you for providing this script it is really helpful! I am having one issue though that maybe you can shed some light on.   I am using the scrip almost identically as you have posted it, the only difference being that I am displaying and formatting the time as well. The issue that I'm having is that 2 hours are being added to the time when output from script token. When I view the data in Marketo I see the correct date/time originally submitted from my form, but after I format the date within my email the time has two hours added to it every time.       ## standard Velocity date/time includes #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_York") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601DateOnly = "yyyy-MM-dd" ) #set( $ISO8601DateTime = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) ## your business-specific friendly date format #set( $FORMAT_FRIENDLY_DATE_ONLY = "MMMM dd, yyyy h':'mm a" ) ## cast date-like String to Date #set( $requestMeetingDate = $convert.parseDate( $member.requestMeetingDate, $ISO8601DateTime, $defaultLocale, $defaultTimeZone ) ) ## output in format ${date.format($FORMAT_FRIENDLY_DATE_ONLY,$requestMeetingDate,$defaultLocale,$defaultTimeZone)}       Kevin ... View more

Hi Sanford,   Thank you as well for your reply! Although I will most likely use the previous suggestion, it is great to know that this is possible. I can also see other applications for a solution like this and will keep this in mind for future use. ... View more

Hi   Salytics,   Thank you for taking the time to provide this solution. I was thinking of something along this line but your use of Now Was Created and OR is key here for me.     ... View more