Hi Andy,
Thanks for the quick solution! I imported the new module and was able to use the new function as follows:
xs:date(dates:parseDate($trial/completion_date)//value/text()) <= fn:current-date()
I verified the correctness for ~300 dates and the logic appears solid (for the kind of dates discussed below).
Any chance this could find its way into a BaseX release?
Best, Ron
On November 5, 2018 at 10:27:48 AM, Andy Bunce (bunce.andy@gmail.com) wrote:
Hi Ron,
I took a quick look at Joe's module and made the following changes:
1. Change datetime:format-date(..,"yyyy-MM-dd") to format-date(..,"[YYYY]-[MM]-[DD]") 2. *Change xdt*:dayTimeDuration("P1D") -> *xs*:dayTimeDuration 3. Change function in namespace *local:* to *dates:*
And saved as a gist [1]. Then in BaseX
import module namespace dates = "http://xqdev.com/dateparser https://urldefense.proofpoint.com/v2/url?u=http-3A__xqdev.com_dateparser&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=wSyNTnK69xJeik7x5IxCLRt7PrrO28V-8jSVck27iww&s=sADX9f7jGPXSqviT-mIVK6uu0h1KSFz4E2tV1u6qgvI&e=" at " https://gist.githubusercontent.com/apb2006/ee0effdd53ca80daf4f1b3e99794ed89/... https://urldefense.proofpoint.com/v2/url?u=https-3A__gist.githubusercontent.com_apb2006_ee0effdd53ca80daf4f1b3e99794ed89_raw_7eedb8343c3cbf0e4ef0063be5af532e8bbfe485_date-2Dparser.xqm&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=wSyNTnK69xJeik7x5IxCLRt7PrrO28V-8jSVck27iww&s=Nmj_UydJx1eMVXLbIyF5CfNVy6fAvikicbuI_kJzxls&e= ";
dates:parseDate("March 2017")
Returns <date resolution="month"> <range> <start>2017-03-01</start> <end>2017-03-31</end> </range> <value>2017-03-01</value> </date>
Joe, I think all these changes are compatible with eXist too? [2]
Hope this helps. /Andy
[1] https://gist.github.com/apb2006/ee0effdd53ca80daf4f1b3e99794ed89 https://urldefense.proofpoint.com/v2/url?u=https-3A__gist.github.com_apb2006_ee0effdd53ca80daf4f1b3e99794ed89&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=wSyNTnK69xJeik7x5IxCLRt7PrrO28V-8jSVck27iww&s=c2tQIVKVH2ZgccsDKII0OHq6wrgN6Bmgazlx9hTfv7s&e= [2] https://sourceforge.net/p/exist/mailman/message/34988159/ https://urldefense.proofpoint.com/v2/url?u=https-3A__sourceforge.net_p_exist_mailman_message_34988159_&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=wSyNTnK69xJeik7x5IxCLRt7PrrO28V-8jSVck27iww&s=SuWEw26jNiCrBlPLzjym5JzZSIECNWAADDEmjTIZevo&e=
On Mon, 5 Nov 2018 at 02:03, Ron Katriel rkatriel@mdsol.com wrote:
Hi Joe,
Thanks for sharing that. I tried adapting your eXist port to BaseX and ran into issues with namespaces. At this point I don’t have the time or expertise to complete this but hopefully someone else will take up the challenge.
Best, Ron
On November 3, 2018 at 12:19:49 AM, Joe Wicentowski (joewiz@gmail.com) wrote:
Hi Ron,
You might find Ryan Grimm's date-parser library module useful if you have a larger range of date formats to handle:
https://github.com/marklogic-community/commons/blob/master/dates/date-parser... https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_marklogic-2Dcommunity_commons_blob_master_dates_date-2Dparser.xqy&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=e-vvgsru1Z5x9LvDMbzC4IlnNmLD9Gh74LxZE20a3-A&s=QXbGrJ9vbbC9tQ9k_8qdKN-M6_zHwScCTYBIHAAlxbc&e=
While it was written with some MarkLogic-specific code, I adapted it for use with eXist (but haven't tested it with BaseX):
https://github.com/HistoryAtState/twitter/blob/master/modules/date-parser.xq... https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_HistoryAtState_twitter_blob_master_modules_date-2Dparser.xqm&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=e-vvgsru1Z5x9LvDMbzC4IlnNmLD9Gh74LxZE20a3-A&s=AGe6aYSio39Gb6aYBk41uIcAk3LA3ex3jxCg1ZUCA3M&e=
Best, Joe
On Fri, Nov 2, 2018 at 6:48 PM Ron Katriel rkatriel@mdsol.com wrote:
Hi Christian,
Much appreciated! I hardened the code (see below) since the dates (from CT.gov https://urldefense.proofpoint.com/v2/url?u=http-3A__CT.gov&d=DwMFaQ&c=fi2D4-9xMzmjyjREwHYlAw&r=44jDQvzmnB_-ovfO6Iusj0ItciJrcWMOQQwd2peEBBE&m=e-vvgsru1Z5x9LvDMbzC4IlnNmLD9Gh74LxZE20a3-A&s=sTeb3eQJ-UU9JJcyp70O4qY6e-PGeWQUHJJhfe3A9uE&e=) occasionally also have the day of the month (e.g., “March 21, 2014”). Currently the function is dropping the day in such cases but I will look into capturing it in a future iteration.
Best, Ron
declare function local:to-date($string) { if (fn:matches($string, '[A-Za-z]+ [0-9]+') or fn:matches($string, '[A-Za-z]+ [0-9]+, [0-9]+')) then let $m := index-of($MONTHS, substring-before($string, ' ')) let $y := xs:integer(functx:substring-after-last($string, ' ')) return xs:date(string-join( ( format-number($y, '0000'), format-number($m, '00'), '01' ), '-') ) else () };
On November 2, 2018 at 4:20:41 PM, Christian Grün ( christian.gruen@gmail.com) wrote:
Hi Ron,
If your timestamp is available in IETF format, you can use fn:parse-ietf-date [1]. Otherwise, you’ll need to write a simple function by yourself:
declare variable $MONTHS := ( 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December' );
declare function local:to-date($string) { let $m := index-of($MONTHS, substring-before($string, ' ')) let $y := xs:integer(substring-after($string, ' ')) return xs:date(string-join(( format-number($y, '0000'), format-number($m, '00'), '01' ), '-')) }; local:to-date('March 2017')
Best, Christian
[1] https://urldefense.proofpoint.com/v2/url?u=https-3A__www.w3.org_TR_xpath-2Df...
On Fri, Nov 2, 2018 at 9:09 PM Ron Katriel rkatriel@mdsol.com wrote:
Hi,
Is there a BaseX function for converting a string date in the form of
“March 2017” to xs:date or xs:dateTime?
Thanks, Ron