[tw5] Re: convert date in a text field to date format

2021-08-17 Thread
Mark, yes, Eric's macro is there, tagged as ' $:/tags/Macro'. I downloaded an emty Wiki - 'published-tw' field will also not be filled. To use the "Update Publication Dates" button is a workaround but not the best solution. I miss a system '*date*' field, like '*created*' or '*modified*'. When

[tw5] Re: convert date in a text field to date format

2021-08-16 Thread 'Mark S.' via TiddlyWiki
[image: screenshot-converted-date.png] On Monday, August 16, 2021 at 3:57:54 PM UTC-7 Mark S. wrote: > > So, did you add Eric's macro to your TW and verify it works? That would be > the first step in trouble-shooting. Remember, after loading the convertdate > macro, you have to save and reload

[tw5] Re: convert date in a text field to date format

2021-08-16 Thread 'Mark S.' via TiddlyWiki
So, did you add Eric's macro to your TW and verify it works? That would be the first step in trouble-shooting. Remember, after loading the convertdate macro, you have to save and reload your TW file. It worked for me without problem: On Monday, August 16, 2021 at 12:30:13 PM UTC-7 S²

[tw5] Re: convert date in a text field to date format

2021-08-16 Thread
Mark, thanks for feedback. The added 'published-tw' field is empty - no values: [image: published-tw.png] Mark S. schrieb am Montag, 16. August 2021 um 20:31:28 UTC+2: > So what you really need is a filter operator that can do the conversion > and be used inside a sortsub operator. @Eric ? > >

[tw5] Re: convert date in a text field to date format

2021-08-16 Thread 'Mark S.' via TiddlyWiki
So what you really need is a filter operator that can do the conversion and be used inside a sortsub operator. @Eric ? If you're willing to use an "update" button, one solution would be a button that creates "published-tw" (date in TW format) fields for any tiddler that has a "published"

[tw5] Re: convert date in a text field to date format

2021-08-16 Thread
Hello, thanks for all input and effort. It looks like it is not so easy... As I wrote, I use the text field ‘publish’ to add a date. (date modified or created will not help me) This date can also be in the future. Format is *T. * - (eg. *7. April 2021* or *13. August 2021*) – this

[tw5] Re: convert date in a text field to date format

2021-08-15 Thread Eric Shulman
On Sunday, August 15, 2021 at 4:47:47 PM UTC-7 Mark S. wrote: > Just tried > <> > and got a hard RSOE ("from" not defined). I think the arguments need to be > tweaked in the macro. > OOPS! I had originally used "date" and "format" as the parameter names, but then I decided to change to using

[tw5] Re: convert date in a text field to date format

2021-08-15 Thread 'Mark S.' via TiddlyWiki
On Sunday, August 15, 2021 at 5:08:35 PM UTC-7 TW Tones wrote: > Format T. ? > > Surely you mean "0DD. MMM " > > That's a good point. I imagine S2's source application is using some local formatting code (e.g. German, Dutch). So the format would have to be altered to the ISO

[tw5] Re: convert date in a text field to date format

2021-08-15 Thread TW Tones
Format T. ? Surely you mean "0DD. MMM " In this case you would parse this date to extract the DD, MMM and as separate values, convert from MMM to a month number with a 12 month table, then re-assemble them into a tiddlywiki date/time string. I suggest 1200 or 12 noon as the

[tw5] Re: convert date in a text field to date format

2021-08-15 Thread 'Mark S.' via TiddlyWiki
@ Eric Just tried <> and got a hard RSOE ("from" not defined). I think the arguments need to be tweaked in the macro. HTH On Friday, August 13, 2021 at 2:53:09 PM UTC-7 Eric Shulman wrote: > On Friday, August 13, 2021 at 12:36:11 AM UTC-7 S² wrote: > >> I use a created text field

[tw5] Re: convert date in a text field to date format

2021-08-15 Thread 'Mark S.' via TiddlyWiki
Is your source text field in T. format? Are you converting it back to TW format? Where are you storing the converted value? On Friday, August 13, 2021 at 12:36:11 AM UTC-7 S² wrote: > Hello forum, > > I use a created text field 'published', which will be filled with a date. > (This

[tw5] Re: convert date in a text field to date format

2021-08-14 Thread
Hello Eric, thanks for the new macro, but I have no idea, how to assign it :-( Regards Stefan Eric Shulman schrieb am Freitag, 13. August 2021 um 23:53:09 UTC+2: > On Friday, August 13, 2021 at 12:36:11 AM UTC-7 S² wrote: > >> I use a created text field 'published', which will be filled with a

[tw5] Re: convert date in a text field to date format

2021-08-13 Thread Eric Shulman
On Friday, August 13, 2021 at 12:36:11 AM UTC-7 S² wrote: > I use a created text field 'published', which will be filled with a date. > (This date can also be in the future) > format is *T. * - (eg. *7. April 2021* or *13. August 2021*). > > 1. How can this be converted into a date

[tw5] Re: convert date in a text field to date format

2021-08-13 Thread
Hello Mark, the displayed field in TOC should be unchanged, as I filled it: *T. * - (eg. *7. April 2021* or *13. August 2021*). Stefan Mark S. schrieb am Freitag, 13. August 2021 um 20:35:40 UTC+2: > I would use a whole bunch of the new search-replace filters. What is your > target

[tw5] Re: convert date in a text field to date format

2021-08-13 Thread 'Mark S.' via TiddlyWiki
I would use a whole bunch of the new search-replace filters. What is your target date format? On Friday, August 13, 2021 at 12:36:11 AM UTC-7 S² wrote: > Hello forum, > > I use a created text field 'published', which will be filled with a date. > (This date can also be in the future) > format