_Vin_ Posted December 8, 2021 Share Posted December 8, 2021 (edited) I have multiple fields for date on each page and that repeats on many pages. Is there a way to have the date auto input itself? It would start with January 1st until December 31st. Date format very likely would be 01.01.2022. or 1. January 2022. Though month names won't be in English. I'm making a planner with a week per two pages and I'm trying to find out if I can avoid manually adding dates for each day of the week. I'm working in Publisher. Edited December 8, 2021 by _Vin_ Forgot to add which program Quote Link to comment Share on other sites More sharing options...
Komatös Posted December 8, 2021 Share Posted December 8, 2021 Hello and welcome to the forums, @_Vin_. My only solution I can think of here would be to work with data merging. To do this, you would have to create a table-like text file with all the daily data for 2022. To do this, you would have to create a table-like file with all the daily data for 2022. For example, like this: Date 01.01.2022 . . . 31.12.2022 _Vin_ and Old Bruce 2 Quote AMD Ryzen 7 5700X | INTEL Arc A770 LE 16 GB | 32 GB DDR4 3200MHz | Windows 11 Pro 23H2 (22631.3085) AMD A10-9600P | dGPU R7 M340 (2 GB) | 8 GB DDR4 2133 MHz | Windows 10 Home 22H2 (1945.3803) Affinity Suite V 2.3.1 & Beta 2.(latest) Better translations with: https://www.deepl.com/translator Need a system wide color picker? Try Microsoft's (New) Power Toys Need a robust PDF Solution? Have a look at Stirling PDF There's nothing you get used to faster than working slowly! Link to comment Share on other sites More sharing options...
_Vin_ Posted December 8, 2021 Author Share Posted December 8, 2021 3 minutes ago, Komatös said: Hello and welcome to the forums, @_Vin_. My only solution I can think of here would be to work with data merging. To do this, you would have to create a table-like text file with all the daily data for 2022. To do this, you would have to create a table-like file with all the daily data for 2022. For example, like this: Date 01.01.2022 . . . 31.12.2022 Thanks, I'll look into how to do that! Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted December 8, 2021 Share Posted December 8, 2021 Another way is to have a simple Text File with the same data in it and then set up a Week Date paragraph style and using linked Text frames you can have the Week Date set to start in a new frame. Considering that this is an annual calendar the Merge function would be better in that you could include in the spreadsheet important dates or information to be included. Just one file and all that stuff would be imported into the correct pages at the same time. The other stuff added is something to think about. _Vin_ 1 Quote Mac Pro (Late 2013) Mac OS 12.7.2 Affinity Designer 2.3.1 | Affinity Photo 2.3.1 | Affinity Publisher 2.3.1 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that. Link to comment Share on other sites More sharing options...
Komatös Posted December 8, 2021 Share Posted December 8, 2021 54 minutes ago, _Vin_ said: Thanks, I'll look into how to do that! I have created a table for you as an Excel file and in CSV format. But, sorry they are in german language. 🖖🏼 Kalenderdaten 2022.xlsx Kalenderdaten 2022.CSV Quote AMD Ryzen 7 5700X | INTEL Arc A770 LE 16 GB | 32 GB DDR4 3200MHz | Windows 11 Pro 23H2 (22631.3085) AMD A10-9600P | dGPU R7 M340 (2 GB) | 8 GB DDR4 2133 MHz | Windows 10 Home 22H2 (1945.3803) Affinity Suite V 2.3.1 & Beta 2.(latest) Better translations with: https://www.deepl.com/translator Need a system wide color picker? Try Microsoft's (New) Power Toys Need a robust PDF Solution? Have a look at Stirling PDF There's nothing you get used to faster than working slowly! Link to comment Share on other sites More sharing options...
_Vin_ Posted December 10, 2021 Author Share Posted December 10, 2021 Thank you, very nice of you! I knew how to make that, data merging is new to me, but I figured it out via tutorials. Quote Link to comment Share on other sites More sharing options...
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.