locked
Mail merge date field displays incorrect data RRS feed

  • Question

  • Hi Everyone,

    I am having difficulties with date fields in a CRM 2013 mailmerge template. I searched multiple mail merge forums, but did not find any helpful advice, so I am beginning to think the issue might be CRM-related.

    I am using a date-only field in my template, and I get date and time in the result, ie. for today's date, I get 2015.03.23. 0:00.

    I only need to display date, so the first thing I tried was the following format:

    {MERGEFIELD My_Datefield /@ "yyyy.MM.dd"}

    Instead of 2015.03.23. I got 2000.03.23., and I can't figure out why. The problem persists on every possible explicit datetime formatting. If I leave it as-is, I get the correct date.

    Any ideas?

    Regards,

    Adam

    Monday, March 23, 2015 1:28 PM