How to convert a date to string in an export with format

[johnbrugman]

Hi there,

I want to export a date value to an file to use it for mail merge in MS Word. In a table or query i am able to format the layout, i.e. I can layout the value '30-4-2002' to '30 april 2002'. When I export the date value I don't know how to get the value '30 april 2002' exported. I don't know if this is possible at all.

Can anyone help me out?

John.

 

[scking]

Merely create your query, format your field and export it as a .txt, .csv, .asc, or whatever. If you can see it in the query you can export is as that value.

Steve King Growth follows a healthy professional curiosity

 

[johnbrugman]

Unfortunately this is not the case. The export format differs from the format in the query. The export format can only be all combinations of D, M, Y and you can specify the in between sign (like a -) but you can't specify a intelligent format.

Kind regards,

John.

 

[johnbrugman]

I found the solution myself or actually my wife did. I needed the formatted date field in a MailMerge and I wasn't aware that you can add options to a MERGEFIELD. But by adding \@ "d MMMM yyyy" to the mergefield I got exactly what I want, exmaple { MERGEFIELD Datum_eerste_aanschr \@ "d MMMM yyyy" }.

Thanks to my wife!