3

I have a question; we are trying to send an appointment confirmation through Journey Builder. Now we are struggling to get the time right. It looks like there is added 1 and sometimes 2 minutes to the time. What are we doing wrong?

The data in the source data extension is: 1/11/2019 11:00:00 AM

We tried to format this into 3 desired values the following way:

%%[  
SET @StartDate = FormatDate(Event:StartDateTime, "dd MMMMM YYYY",, "nl-NL")  
SET @StartDay = FormatDate(Event:StartDateTime, "ddddd",,"nl-NL")  
SET @StartTime = FormatDate(Event:StartDateTime, "HH:mm",,"nl-NL")   
]%%

In the email it displayed the following time at the @StartTime 11:01, there is added an extra minute. Does someone know why?

1
  • you could potentially try using DatePart() function to retrieve Hours and Minutes, but not sure if it will cause same issue - that is a weird bug. I would definitely report that to SFMC . Have you tried setting the Event:StartDateTime to a var and using that? perhaps there is some miscommunication between the function and the data pull from SFSC? Commented Jan 15, 2019 at 15:20

1 Answer 1

0

I also tested it and it doesn't work, strange.

You can use Format instead of FormatDate like:

Format(Event:StartDateTime, 'HH:mm', 'Date', 'nl-NL') 
3
  • Can you tell me where i can find a documentation of Event:StartDateTime? Is it activity specfic inside the journeybuilder (aka when the email activity has been reached) or is it the time when the journey triggered or even something different? Or is it a EventDescription when you use an "Event" as entrysource rather than an dataextension? Or is it something from other platforms like Salescloud? Commented Jan 15, 2019 at 9:25
  • I couldn't find a detailed document but it is from SalesCloud and you can see this link to get a visual: success.salesforce.com/answers?id=9063A000000Dju0QAC Commented Jan 15, 2019 at 9:33
  • @SelimSevim, thanks! Fixed the issue by using format. The problem was the FormatDate function.
    – Klaas Faze
    Commented Jan 17, 2019 at 15:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .