When we use the strings %%order_valid_from%% and %%order_valid_to%% the date is followed by a time stamp. We wish to remove this time stamp as the stamp is defined in AM/PM and in Denmark we don't use that.

How do I remove the time stamp from the two strings?

1 Answer 1


I suppose you retrieve the data from a data extension but you can format the date based on the locales. For example:

FormatDate(Now(), "MMM dd, yyyy", "HH:mm:ss.tt", "da_DK")

Its output is something like:

dec 02, 2017 20:37:20

You can change Now() function with your field name.

  • Thank you. And where would you place the function?
    – user51635
    Commented Dec 4, 2017 at 8:02
  • Could you please tell me where you retrieve the data for order_valid_from and order_valid_to? From a landing page or data extension? Commented Dec 4, 2017 at 8:26
  • A data extension
    – user51635
    Commented Dec 8, 2017 at 11:37
  • Can you please share its screenshot with the fields in it for better understanding? Commented Dec 8, 2017 at 14:19

You must log in to answer this question.

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