Macro works in one document but creates error in others

[kod65red]

I am trying to create a macro to enter a custom format date quickly, like "19 June 2011" instead of "06/19/11." I'm using a macro since openoffice.org doesn't allow you to change the default format.

I've tried creating such a macro a few times, saving it in My Macros. It works well in the original document when I first create it; however, if I open another document or even save the first document, close it, and open it again, the macro malfunctions, producing a field like "40713.57" instead of a date. (When I rerecord the macro, I get slightly different numbers.) I've done similar things with a time macro and had the same problem. Any suggestions?

[floris_v]

See this thread in the new forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=24779
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum

[kod65red]

That is the same issue, for sure - it's not resolved there yet. Is that the forum I should be using, rather than this one?

[probe1]

Using a document template with a customized date field is the easiest solution.

AutoText another one.

Or a macro that sets the format... see my Extension DateTime2
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs

[kod65red]

Thanks. I think I resolved it more or less via the following work-around: a document template with a customized date field per your first suggestion. Not too elegant, since the date and time now appear at the top of every new default document, and the macros don't work in old documents until I add a custom-formatted date. If anyone knows a more elegant solution, let me know. I may try out your custom macro as well. Thanks!

[JohnV]

Try the AutoText solution.
http://www.oooforum.org/forum/viewtopic.phtml?t=124595