[tw5] Re: ISO date query

Thanks Eric, I did refer back to that but forgot about the lack of puncutuation and 7 zeros it is. Thanks for the explanation. Regards Jon On Tuesday, 9 June 2020 19:01:09 UTC+1, Eric Shulman wrote: > > On Tuesday, June 9, 2020 at 9:55:36 AM UTC-7, Jon wrote: >> >> Can I just check - is it 6

[tw5] Re: ISO date query

On Tuesday, June 9, 2020 at 9:55:36 AM UTC-7, Jon wrote: > > Can I just check - is it 6 or 7 zeros after the 12 as you've included > both? > As I noted previously, the full format for a tiddler date field (i.e., "created" and "modified") is: 0MM0DD0hh0mm0ss0XXX where is a 4-digit

[tw5] Re: ISO date query

Hi Tony, thanks for the info. Is the button text incomplete? (<$action tiddlers...) - I don't know enough to fill in any blanks! Can I just check - is it 6 or 7 zeros after the 12 as you've included both? Thanks Jon On Tuesday, 9 June 2020 09:11:07 UTC+1, TonyM wrote: > > Jon, > >

[tw5] Re: ISO date query

Jon, 1200 is 12 Noon is is filled out to look as a standard date, Yes, I found setting it 00 hours is less helpful. It is a valuable lesson to learn how to apply something to a set of tiddlers you can aplly to one tiddler; <$button> <$list filter="selected all relevant tiddlers"> <$action

[tw5] Re: ISO date query

Hi Tony, Thanks for the suggestion, but my skills as they are mean I don't know how to apply this for all the records. The notepad option works really well as I can just copy the date column from the spreadsheet (containing 3.5 thousand rows) and paste into Notepad ++ and apply the regex to

[tw5] Re: ISO date query

Jon, You can apply regex in tiddlywiki, so perhaps you can use your notpad++ method? I will suggest once again (forcefully) if you want a global solution, then convert dates to the system date format then you can use $view date to display any format, including the relative date. If your

[tw5] Re: ISO date query

Hi Hubert, Thanks for this, which I'll be able to use down the line but at the moment, I wouldn't know how apply this globally. However, I've managed to find a solution using a text editor like Notepad ++. Instructions below for anyone else looking for this. So, to convert 18/09/10 to

[tw5] Re: ISO date query

Hi Jon, You can use this ugly macro below to "convert" any string like this: "20/06/07" into this: "2020/06/07", assuming that the earliest year in your range is the year 2000. Paste this macro definition in a new tiddler: \define UpdateDate(date) <$vars y={{{

[tw5] Re: ISO date query

Thanks Tony - I think I need to wait for the long answer Regards Jon On Monday, 8 June 2020 12:28:43 UTC+1, TonyM wrote: > > 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

[tw5] Re: ISO date query

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

[tw5] Re: ISO date query

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

[tw5] Re: ISO date query

On Sunday, June 7, 2020 at 8:51:11 AM UTC-7, Jon wrote: > > I plan to use TW5-JsonMangler > to import a diary as a > .csv file into my wiki so that each row is a new tiddler with the date as > the name. > The dates are in the format 20/06/07