Nov 4, 2012 at 8:26 AM
Edited Nov 6, 2012 at 6:15 AM
I have a suspicion why I have a problem with the query ...
first the problem I see in the DB .sdf:
Commom_CommonPartRecord shows correctly for all 3 dates 4.11.2012 08:32:55 for created, published, modifiedUTC
(same for Commom_CommonPartVersionRecord)
Orchard_Framework_ContentItemVersionRecord I see for my DateEnd
<DateEnd>2012-11-03T23:00:00.0000000Z</DateEnd> ("DateEnd" is my field name;I added it using the pop-up calendar; and its defined as 'date' only!)
My ContentItem (on user screen) also shows "4.11.2012"
Now, If Orchard compares (DateEnd>= today) with this date it would explain why in 'queries' I have to set offset "-1" !
? which record is used to do the comparison ?
? <DateEnd>2012-11-03T23:00:00.0000000Z</DateEnd>; does this mean it's the beginning of 201-11-04 ? I'm confused.
Thanks for your time and advise