Convert data from string to date

[aturcan]

Hi. I have a data source that cannot be adjusted. A field that is supposed to be a date field is actually pushed into word a string. So my mail merge doesn't see it a date source and thus doesn't format it using the \@ switch.

For example, I have "2/1/2025" coming into Word through a a MailMerge field. But it's actually a string piece of data, not a date.

How do I convert it into a Word date data field?



Thank you.

[macropod]

It shouldn't matter whether the data are coming through as strings - the date field switches (e.g. \@ "DDD D MMMM YYYY") should still be able to provide the required formatting - you don't need to convert the data to a Word DATE field (which wouldn't be possible anyway).

[aturcan]

Thank you for your input. Do you know what could be causing it to not work then? The data coming in is 2/1/2025 and none of the date switches work with it.

[macropod]

Without seeing some sample data and the mailmerge fields you're processing it with, I can't provide further advice.