Jump to content

Recommended Posts

Posted

The attached file is an example of the report produced by Charting Companion which is unable to display dates in the standard genealogical format of D MMM YYYY, but is governed by Windows settings' Short Date; e.g. 3/25/1759

Is it possible using AffPub2, to change the date format? e.g., 25 Apr 1759

The only document format Charting Companion produces is .rtf

Thank you for any reply.

Kind regards,

Kelly

FYI & FWIW - Windows 10, Settings, Time & Language, Date & Time, Related settings, Date, time & regional formatting, Regional format data, Change data formats, the list of available formats doesn't support d mmm yyyy

image.png.840bcf0486dbe8da7dea00f9532d9608.png

descendant report 20250203 0832.pdf

Posted

When inserting or editing a date field, click the More (ellipsis) icon to the right of the field name in the Fields panel. You will find presets and a custom option to use any date and/or time format you need. Affinity uses the standard syntax which you can find here:

https://affinity.help/publisher2/English.lproj/index.html?page=pages/Advanced/fields.html&title=Fields

Posted
34 minutes ago, Kelly Bellis said:

Is it possible using AffPub2, to change the date format? e.g., 25 Apr 1759

This is the default format that I get, so I suspect that it may be based on a regional setting. If you don't see the option you want when inserting a field, you can set a custom format.

Untitled.png.8bb0a01de002a3eb254b1cbd1efa7c2a.png

Acer XC-895 : Core i5-10400 Hexa-core 2.90 GHz :  32GB RAM : Intel UHD Graphics 630 : Windows 11 Home
Affinity Publisher 2 : Affinity Photo 2 : Affinity Designer 2 : (latest release versions) on desktop and iPad

"Beware of false knowledge, it is more dangerous than ignorance." (GBS)

Posted
31 minutes ago, MikeTO said:

When inserting or editing a date field, click the More (ellipsis) icon to the right of the field name in the Fields panel. You will find presets and a custom option to use any date and/or time format you need. Affinity uses the standard syntax which you can find here:

https://affinity.help/publisher2/English.lproj/index.html?page=pages/Advanced/fields.html&title=Fields

If the original .rtf document is Placed (Ctrl+Shift+m) into a new AffPub2 document, and the Date & Time, Custom, and Pattern entered, the date format display doesn't change. I'm guessing because the date; e.g., 3/25/1759, is not actually a field, just a text string.

image.png.6ab5a16ebdd9e94626c88d54e31bedde.png

Posted
4 minutes ago, Kelly Bellis said:

If the original .rtf document is Placed (Ctrl+Shift+m) into a new AffPub2 document, and the Date & Time, Custom, and Pattern entered, the date format display doesn't change. I'm guessing because the date; e.g., 3/25/1759, is not actually a field, just a text string.

That's correct, date/time fields exported to RTF from MS Word will be plain text and not a field. But even if you import a docx file into Publisher, the field will be converted to plain text so you'll need to replace all of those after importing the document.

Posted
44 minutes ago, PaulEC said:

This is the default format that I get, so I suspect that it may be based on a regional setting. If you don't see the option you want when inserting a field, you can set a custom format.

Untitled.png.8bb0a01de002a3eb254b1cbd1efa7c2a.png

Thank you Paul.

I'm not inserting any fields. I'm trying to change all instances where the date format in the .rft document produced by Charting Companion is determined by Window's Regional Settings for Short Date; e.g., 3/25/1759 and to change them to 25 Mar 1759.

I may have to approach this date format change using regexp before Placing it (Ctrl+Shift+m) into an AffPub2 document.

Posted
4 minutes ago, MikeTO said:

That's correct, date/time fields exported to RTF from MS Word will be plain text and not a field. But even if you import a docx file into Publisher, the field will be converted to plain text so you'll need to replace all of those after importing the document.

Thanks Mike.

I don't think that Microsoft Word isn't involved with Charting Companion, though WordPad may be somehow used by this program in it producing the .rtf, its only output offered. As I mentioned in reply to Paul, I may need to fix this before bringing it into AffPub2 using LibreOffice Writer's Find & Replace and regular expressions.

I just did a quick search through AffPub Help for regexp without finding any results. However, I did find it and will play with that next - after we shovel this mornings snow : )

image.png.75b1c8666d3d974b99fb2115f1d016d1.png

 

Posted

image.png.75ec0d9bb29ac0499f3a17bb632ef6f5.png

Thanks to some help from the developer, and going through Control Panel - not Windows Settings - I was able to define the new Short date format.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.