Date format in email URL button

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I'm using the &URLEncode([Date Field]) formula as part of an email url button formula. 

I've change all date formats in all of our apps to DDMMYYYY but when the email button populates a draft, the dates on it is formatted as MMDDYYYY. Is there a way to use ToFormattedText(Date d, Text format) within the existing url formula or is that too much? 


Please help, thanks!

Photo of Jean-Christer

Jean-Christer

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 930 Points 500 badge 2x thumb
You would do something like this in your formula:

&URLEncode(ToFormattedText([Date Field], "DDMMYYYY"))

So first [Date Field] is formatted, then you URLEncode it.
Photo of Jean-Christer

Jean-Christer

  • 0 Points
Thank you! Worked really well :)
Photo of Xavier Fan

Xavier Fan, Champion

  • 930 Points 500 badge 2x thumb
Great!