Re: [Exist-open] Simple Question

[Adam R. <ad...@ex...>]

Otherwise - datetime:date-from-dateTime(...) works well

On 11 March 2010 10:04, Pieter Deelen <pie...@gm...> wrote:
> On Thu, Mar 11, 2010 at 4:52 AM, Greg Bardwell <bar...@gm...> wrote:
>> Perhaps it is just getting late, but...
>> I am trying to get elements with a dateTime attribute between 2 dates --
>> seems simple enough.
>> I tried:
>> collection($FTcollection)/doc[xs:date(substring(@addedDate, 1, 10)) >=
>> xs:date($data/startDate)][xs:date(substring(@addedDate, 1, 10)) <=
>> xs:date($data/endDate)]
>> and
>> collection($FTcollection)/doc[xs:date(substring(@addedDate, 1, 10)) >=
>> xs:date($data/startDate) and xs:date(substring(@addedDate, 1, 10)) <=
>> xs:date($data/endDate)]
>> And other variations.
>> I used the substring to pull the date only from the addedDate dateTime.
>> I keep getting: err:FORG0001: illegal lexical form for date-time-like value
>> ''  [at line 54, column 33] [at line 54, column 33]
>
> I don't think it's the cause of your problem, but a cleaner and more
> robust way to get the date component from a dateTime string is to use
> this expression: xs:date(xs:dateTime(@addedDate)).
>
> Regards,
> Pieter
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open
>



-- 
Adam Retter

eXist Developer
{ United Kingdom }
ad...@ex...
irc://irc.freenode.net/existdb