Staff Sean P Posted September 4, 2023 Staff Posted September 4, 2023 Hi Mike, To answer your questions: 1. This is nothing to do with adding an extra hour to the times. The k/H difference is essentially what the 12am is referred to as in a 24 hour clock. With k 12am is displayed as 24 rather than 00. Meaning the clock runs from 1am all the way through to 24am. Where as using H, 12am is displayed as 00. The K/h difference is the same thing but with a 12 hour clock. With K 12am is displayed as 00am and h displays it as 12am. Here is a quick example showing these values: 2. From what I can tell and looking at the actual ICU documentation and their test examples (icu4c\source\test\intltest\dtfmttst.cpp inside icu-cldr-2023-08-22) this behaviour is correct. For standard English data (seen by the en, rather than en-GB) they're expecting what I'm getting for the US. For US I'm getting GMT+1 and British Summer Time, and for UK I'm getting BST and British Summer Time. 3. This button will update the 'Current Date & Time' of the selected field to be the current date/time, rather than what it was at time of insertion. 4. Cheers - I can confirm I am getting this in the app. I'll pass this over to documentation. 5. The example is just showing how a time zone that differs in minutes as well as hours will look. This is how UTC+04:30 Kabul looks: 6. Thanks I'll get this fed back to the documentation team as well. Quote
MikeTO Posted September 4, 2023 Posted September 4, 2023 4 hours ago, Sean P said: With k 12am is displayed as 24 rather than 00. Meaning the clock runs from 1am all the way through to 24am. Where as using H, 12am is displayed as 00. The K/h difference is the same thing but with a 12 hour clock. With K 12am is displayed as 00am and h displays it as 12am. Oh my mistake, I misunderstood the purpose of that pattern. Sorry. 4 hours ago, Sean P said: 2. From what I can tell and looking at the actual ICU documentation and their test examples (icu4c\source\test\intltest\dtfmttst.cpp inside icu-cldr-2023-08-22) this behaviour is correct. For standard English data (seen by the en, rather than en-GB) they're expecting what I'm getting for the US. For US I'm getting GMT+1 and British Summer Time, and for UK I'm getting BST and British Summer Time. I could swear I was seeing the reverse yesterday, that those with UK English couldn't get BST, but I can't duplicate it now so I must have been confused. Sorry. 4 hours ago, Sean P said: 3. This button will update the 'Current Date & Time' of the selected field to be the current date/time, rather than what it was at time of insertion. At least I got one right. I thought that's what it should do and I've now figured out the steps. If you insert the current date & time field into a text frame on a document page it will update correctly but if the same field is inserted into a frame from a master layer it won't update - you can customize the formatting but not update the value. Thanks, Mike Quote Download a free PDF manual for Affinity Publisher 2.5 Download a quick reference chart for Affinity's Special Characters Affinity 2.5 for macOS Sequoia 15.3, MacBook Pro (M4 Pro) and iPad Air (M2)
Staff Sean P Posted September 5, 2023 Staff Posted September 5, 2023 20 hours ago, MikeTO said: At least I got one right. I thought that's what it should do and I've now figured out the steps. If you insert the current date & time field into a text frame on a document page it will update correctly but if the same field is inserted into a frame from a master layer it won't update - you can customize the formatting but not update the value. Thanks, Mike Thanks for that! I've reproduced that here and will get it logged! Thanks for letting us know. MikeTO 1 Quote
tatanka Posted September 13, 2023 Posted September 13, 2023 On 6/26/2023 at 9:42 AM, Ash said: Symbol Meaning Pattern Example Output Notes G era designator G, GG, or GGGGGGGGGGGG AD Anno Domini A Looks like you have omitted CE and BC(E). I would add those, and give them the name ‘Common Era’ and ‘Before Common Era’ respectively. Quote
Hangman Posted September 13, 2023 Posted September 13, 2023 Hi @tatanka, I don't believe they've been omitted, they're simply not included as part of the ICU spec... https://unicode-org.github.io/icu/userguide/format_parse/datetime/ Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
vlimm Posted September 20, 2023 Posted September 20, 2023 In your "custom date formatting" section, I would suggest one modification: This number would make more sense if the output values were 1-12. (i.e., We would never say 0 AM. We would say 12 AM.) Quote
walt.farrell Posted September 20, 2023 Posted September 20, 2023 48 minutes ago, vlimm said: In your "custom date formatting" section, I would suggest one modification: This number would make more sense if the output values were 1-12. (i.e., We would never say 0 AM. We would say 12 AM.) If I understand what they've implemented, they're just following the Unicode standard. Ash mentioned early in this topic that they follow https://unicode-org.github.io/icu/userguide/format_parse/datetime/ Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.3, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1
vlimm Posted September 20, 2023 Posted September 20, 2023 Yes, I saw that too. However, unless Affinity is willing to put in coding that will allow us to mathematically manipulate those numbers (e.g., K+1), this custom formatting is not terribly useful. I understand that following the Unicode standard is a good general principle, but if Affinity wants to avoid providing additional programming capability, a few tweaks are going to be needed to make this custom formatting meaningful. Quote
Petar Petrenko Posted September 20, 2023 Posted September 20, 2023 After 23:59:59 comes 00:00 which is a start of a new day. So, it is absolutely OK. Quote All the latest releases of Designer, Photo and Publisher (retail and beta) on MacOS and Windows. 15” Dell Inspiron 7559 i7 ● Windows 10 x64 Pro ● Intel Core i7-6700HQ (3.50 GHz, 6M) ● 16 GB Dual Channel DDR3L 1600 MHz (8GBx2) ● NVIDIA GeForce GTX 960M 4 GB GDDR5 ● 500 GB SSD + 1 TB HDD ● UHD (3840 x 2160) Truelife LED - Backlit Touch Display 32” LG 32UN650-W display ● 3840 x 2160 UHD, IPS, HDR10 ● Color Gamut: DCI-P3 95%, Color Calibrated ● 2 x HDMI, 1 x DisplayPort 13.3” MacBook Pro (2017) ● Ventura 13.6 ● Intel Core i7 (3.50 GHz Dual Core) ● 16 GB 2133 MHz LPDDR3 ● Intel Iris Plus Graphics 650 1536 MB ● 500 GB SSD ● Retina Display (3360 x 2100)
anto Posted October 13, 2023 Posted October 13, 2023 In excel i have date in format 01.01.2023 When i try to merge data Publisher show in Preview in format 01/01/2023 How to have date like in file xlsx? In version 1.10 this worked well. In 2.2 it does not work. Quote
Hangman Posted October 13, 2023 Posted October 13, 2023 Hi @anto, This appears to be working as expected for me... are you able to upload a sample .xlsx file so we can take a look? Custom Date.mp4 Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
anto Posted October 13, 2023 Posted October 13, 2023 2 minutes ago, Hangman said: are you able to upload a sample .xlsx file so we can take a look I cannot upload because file has private data. I'll try to create new ones and attach it. Quote
Hangman Posted October 13, 2023 Posted October 13, 2023 Just now, anto said: I cannot upload because file has private data. I'll try to create new ones and attach it. Completely understand so any random data is fine just formatted using the same date format... Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
anto Posted October 13, 2023 Posted October 13, 2023 13 minutes ago, Hangman said: Completely understand so any random data is fine just formatted using the same date format... Here is video and file 2023-10-13 15-53-15.mp4 test_date_merge.xlsx Quote
anto Posted October 13, 2023 Posted October 13, 2023 @Hangman maybe it works on Mac and not on Windows? Quote
Hangman Posted October 13, 2023 Posted October 13, 2023 @anto, When I open your file (for me) the dates are all formatted using '/'s Try the attached file and see if it works for you on Windows or whether you see the same issue... test_date_merge_new.xlsx Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
anto Posted October 13, 2023 Posted October 13, 2023 When i open your file it seems to work, but when i press Save, it does not work. 2023-10-13 16-16-20.mp4 Quote
anto Posted October 13, 2023 Posted October 13, 2023 I tried different formats of data and seems that all format that have dot, do not work. Publisher replace dot with / Quote
Hangman Posted October 13, 2023 Posted October 13, 2023 Maybe it is a Windows issue, perhaps others using Windows can also test this to see if they see the same issue with both your original file and my updated file and report back. In the meantime, could you confirm your OS language and the Language setting you're using in Publisher which I assume is either English or English (United States)? Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
anto Posted October 13, 2023 Posted October 13, 2023 1 minute ago, Hangman said: In the meantime, could you confirm your OS language and the Language setting you're using in Publisher Publisher - by default, i do not know what. Windows, LibreOffice - ukrainian Quote
walt.farrell Posted October 13, 2023 Posted October 13, 2023 50 minutes ago, anto said: When i open your file it seems to work, but when i press Save, it does not work. When I use @Hangman's xlsx file it works, and even if I open it in LibreOffice and re-save it, it still works for Data Merge in Publisher. LibreOffice tells me that your file, @anto, is formatted using the / format rather than the . format. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.3, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1
Hangman Posted October 13, 2023 Posted October 13, 2023 4 minutes ago, walt.farrell said: LibreOffice tells me that your file, @anto, is formatted using the / format rather than the . format. That is what Excel, Google Sheets and Apple Numbers all tell me as well... walt.farrell 1 Quote Affinity Designer 2.5.7 | Affinity Photo 2.5.7 | Affinity Publisher 2.5.7 Affinity Designer Beta 2.6.0.3106 | Affinity Photo Beta 2.6.0.3106 | Affinity Publisher Beta 2.6.0.3106 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
anto Posted October 13, 2023 Posted October 13, 2023 Just now, Hangman said: That is what Excel, Google Sheets and Apple Numbers all tell me as well... What does this mean? They don't tell me anything. Quote
anto Posted October 13, 2023 Posted October 13, 2023 9 minutes ago, walt.farrell said: is formatted using the / format rather than the . format what does this mean? Quote
walt.farrell Posted October 13, 2023 Posted October 13, 2023 2 minutes ago, anto said: what does this mean? That you created it using the / format, as far as LibreOffice can tell (and as far as Excel, Google Sheets, and Apple Numbers can tell). What application did you use to create the file you shared with us? Can you open that test file in that application and show us the Date-formatting options you used? Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.3, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1
Recommended Posts
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.