Quick answer Longer one later, use split[/] to get each part than resemble them with a concatenation
Regards Tony On Monday, June 8, 2020 at 4:11:32 PM UTC+10, Jon wrote: > > Thanks Tony & Eric. > > How do I convert a date like 20/06/07 into 2020/06/07? > > The dates are in a spreadsheet and range over 10 years. I first tried > using find & replace eg.replacing '01/' with' 2001/' for 01/02/25 but that > replaces the month field in subsequent dates. > > Regards > Jon > > On Sunday, 7 June 2020 23:08:01 UTC+1, TonyM wrote: >> >> Jon >> >> You can import and reformat later. However I recommend converting the >> incomming date/title to one using the full serial date and put it in its >> own field e.g. published-date. You can then use all the tiddlywiki date >> list and format features on the date. You can leave the title as imported. >> >> I/we can share the code if you want it. >> >> Regards >> Tony >> >> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d170db83-ae25-4d04-a227-fd45838a4f9fo%40googlegroups.com.