Skip to main content
Answer

Date Formatted Field inputting BLANKS in Automation

  • March 1, 2022
  • 2 replies
  • 61 views

Cole_Wedemeier
Forum|alt.badge.img+13

I’ve read the community for how to get the harder-to-read date cleaned up for automation with emails that include that field. I made a new column that formats the date/time to MM/DD/YYY and it populates fine in the table. However, the emails show nothing of that date and just has the space blank in the email.

Here’s the formula I have to set the date format:

Any suggestions?

Best answer by Ben_Young1

Hello Hello!

Could you do me a quick favor and retest your full automation flow starting from the trigger and take a look at the output?

I mirrored your formula and automation and didn’t have any issues with the value being populated into the email.

Generally, I find that retesting the trigger in automation resolves a lot of strange behaviors.

Let me know if it still leads to an empty value in the email preview and we’ll troubleshoot it!

2 replies

Ben_Young1
Forum|alt.badge.img+22
  • Brainy
  • Answer
  • March 1, 2022

Hello Hello!

Could you do me a quick favor and retest your full automation flow starting from the trigger and take a look at the output?

I mirrored your formula and automation and didn’t have any issues with the value being populated into the email.

Generally, I find that retesting the trigger in automation resolves a lot of strange behaviors.

Let me know if it still leads to an empty value in the email preview and we’ll troubleshoot it!


Cole_Wedemeier
Forum|alt.badge.img+13

Hello Hello!

Could you do me a quick favor and retest your full automation flow starting from the trigger and take a look at the output?

I mirrored your formula and automation and didn’t have any issues with the value being populated into the email.

Generally, I find that retesting the trigger in automation resolves a lot of strange behaviors.

Let me know if it still leads to an empty value in the email preview and we’ll troubleshoot it!


@Ben.Young

I had done that a couple times, but I must not have tested from the very start after the last update to the formatting of the date.

Thank you!