Evan, Thanks again for your work.
To the point : *So I suppose I am asking, "can the treatment of empty or blank date fields be restored?", or could you "tell me a way to treat such fields to avoid the errors?"* I will return to blank dates shortly. *Date Format* First, removing the trailing "00" or using 000 does indeed let a date display correctly THANKYOU I was erroneously setting dates to one digit short <$action-setfield $field=date-field $value=<<now YYYY0MM0DD0hh0mm0ss000>> $timestamp=no /> Previously however this was tolerated. As was a date field with only the date YYYY0MM0DD and other combinations (I have not retested) *Blank dates* This behaviour has changed, I am now getting these errors below when previously use of date fields that had empty or a single space in the date field were tolerated and no result was returned, ComputeError: Cannot auto-convert "" to a date! ComputeError: Cannot auto-convert " " to a date! I was using the existence of a date-field to trigger the display, time stamp or edit of that and other fields - For example if item-started existed it allows you to "select, enter or time stamp the date" item-started - Basically the existence of item-started indicates the tiddler is now under disposition management (regardless of its value or not) - It also provides the ability to optionally provide a item-completed or item-cancelled dates - If I accidentally cancelled the item and cleared the item-cancelled date, to instead set the completed date, I would have a blank cancelled date field. *Why permit " " dates* If I am using the existence of a date field empty or otherwise I use a filter that includes has[fieldname] Of note was that this has[fieldname] filter often seemed only to work when the field existed and was not empty, hence the use of " " On example of where formulas was tolerant of blank and space was in the following, which calculates the number of days between the date-fields value and today. \define daystoday(datefield) (= days( now(), date( {{!!$datefield$}} ) ) =) \end Other examples, It is fine for these to return nothing (= if(tw_date({{!!$datefield$}})=now(),"Today","Not Today") =) \define showtodayrange(datefield1,datefield2) <progress value=<<formula "days( date( {{!!$datefield1$}} ) , now() )">> max=<<formula "days( date( {{!!$datefield1$}} ) , date( {{!!$datefield2$}} ))">>/> \end <$if value=(={{!!$datefield$}}=)> Has value (=date({{!!$datefield$}})=) <$set name=indate value= (=date({{!!$datefield$}})=)> </$if> <$else> No Value (={{!!$datefield$}}=) <$set name=indate value=(=now()=)> </$else> The above also seems broken, using The *Condition* plugin for TiddlyWiki, version 0.1.0 (disabled or not) *So I suppose I am asking, "can the treatment of empty or blank date fields be restored?", or could you "tell me a way to treat such fields to avoid the errors?"* Thanks in advance, Tony On Sunday, February 4, 2018 at 12:54:42 PM UTC+11, Evan Balster wrote: > > Hey all — > > Formula 0.2.2 is out: https://evanbalster.com/tiddlywiki/formulas.html > GitHub: https://github.com/EvanBalster/TiddlyWikiFormula > > Changes: > > - Fixed a bug in the parsing of /* block comments */. // line comments > also > work. > - Implemented regular expression literals in the JavaScript style: > /regex/g > - May be used as a Datum > <https://evanbalster.com/tiddlywiki/formulas.html#Datum> > - When converting strings to regex, both JavaScript and TiddlyWiki > styles will be recognized. > - Formula errors now mention LET assignments they lie inside. > - Formulas as Tag Attributes > > <https://evanbalster.com/tiddlywiki/formulas.html#Formulas%20as%20Tag%20Attributes> > are > now facilitated by a mod using the experimental Mod-Loader Plugin > <https://evanbalster.com/tiddlywiki/formulas.html#Mod-Loader%20Plugin>. > > > *Tony* — I fixed some coercion bugs in 0.2.1 but I'm not sure if those > cover the issues you're reporting. > > The blank definitely won't be treated as a date (what would it default to, > anyway?) > > As for the other one, 2017122410592500 isn't quite a valid TiddlyWiki date > under current semantics. > > *2017 12 24 10 59 25 00* > > The last bit (milliseconds) should be either 3 digits or completely > absent. AFAIK TiddlyWiki dates are never expressed to "centisecond" > precision so this looks out of place to me. I'm strict about what Formula > interprets as a date, because these strings of digits could also be numbers. > > > *BurningTree* — that's a nice looking spreadsheet UI. Consider your > experimentation encouraged! > > > On Friday, 2 February 2018 22:30:02 UTC-6, BurningTreeC wrote: >> >> Hi Evan, >> >> I've found this *handsontable* library and tried making a basic widget >> here: spreadsheet widget >> <http://muritest.tiddlyspot.com/#hot%20spreadsheet:%5B%5Bhot%20spreadsheet%5D%5D%20%5B%5Bthe%20tap%20widget%5D%5D%20%5B%5Bthe%20swipe%20widget%5D%5D%20%5B%5BThe%20widthreveal%20macro%5D%5D%20%5B%5BThe%20wheelreveal%20macro%5D%5D%20%5B%5BPredefined%20layouts%5D%5D%20%5B%5BThis%20is%20a%20preview%20for%20what's%20coming%20with%20v0.1.2%5D%5D%20%5B%5Bmy%20creator%20invented%20the%20touchscreen%5D%5D%20%5B%5BHow%20to%20get%20this%20on%20your%20pc%2C%20laptop%20or%20mobile%20device%5D%5D%20%5B%5B4%20TAP%20to%20Tiddler%20MODAL%20and%20LONG%20PRESS%20to%20open%20sidebar%5D%5D%20%5B%5Bautopopulate%20this%20wiki%20with%20images%5D%5D%20%5B%5BCeci%20n%E2%80%99est%20pas%20une%20pipe.%5D%5D%20%5B%5BI%20am%20Mr.%20Van%20Gogh%5D%5D%20%5B%5BI%20am%20one%20of%20that%20guy's%20paintings%5D%5D%20seamless%20%5B%5Bthe%20best%3A%20you%20can%20drag%2010%20Tiddlers%20at%20once.%5D%5D%20%5B%5Bwatch%20muuri%20in%20different%20colors%5D%5D%20%5B%5Brun%20to%20the%20hills!%5D%5D%20%5B%5BThat's%20the%20way%20I%20like%20it!%5D%5D%20%5B%5Bthe%20best%20louvre%20moment%5D%5D%20%5B%5Bmuuri%20is%20the%20finnish%20word%20for%20wall%5D%5D%20%5B%5Banalogue%20clock%5D%5D%20%5B%5Bmuuri%2C%20muuri%20-%20what's%20this%20muuri-bla%20all%20about%3F%5D%5D%20%5B%5Bsave%20wiki%20button%5D%5D%20%5B%5Ba%20little%20bit%20of%20transparency%5D%5D> >> >> The docs <https://docs.handsontable.com/0.35.1/Core.html> look promising >> and the interface is very nice - the license is MIT >> >> Simon >> > -- 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 post to this group, send email to tiddlywiki@googlegroups.com. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d18d8b19-7591-45a5-9aa0-16484ddf6b90%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.