Hi, Recently we have changed our date format in our press releases from dd/ mm/yyyy ( 28/03/2009) to d/M/yyyy ( 5/3/2009 -- in words 5th march 2009).
>From that day our search results are coming up in a confusing way. When I search using month and year i.e. Oct 2006 then it even returns results with date as 10 also i.e. 10th March 2006. I have checked the query it is being formed correctly. Only problem I notice is the press release date is being returned for some press releases incorrectly i.e. the date format returned is yyyy/ dd/mm instead of yyyy/mm/dd. Hence the above mentioned problem . In correct result : <rs constraints="no-constraints" hit="1" locale="en" name="5035.htm" project="corp"> <locale>en</locale> <type>HTML</type> <name>5035.htm</name> <released>true</released> - <guid> standardcontentimpl-ab3293a-11ab8d1c7cd-e8c92fd3248d18a2 </guid> <group>/media_centre/press_releases</group> <description/> <last-updated>2009-03-02 03:30:50.531</last-updated> - <context> ABCDEF </context> - <title> fsdfsdfsdjfsjdjk </title> <Size>1436</Size> <rls_mod_date/> <rls_title>Press Release heading</rls_title> <fielddate/> <MIME-Type>text/html</MIME-Type> <Date/> <Modified/> <rls_date>2009/03/02 00:00:00</rls_date> <size>1436</size> <Title/> <rls_press_date_string>6/3/2006</rls_press_date_string> <fieldcontenttitle/> <rls_teaser/> <rls_searchable/> <rls_press_date>2006/06/03 00:00:00</rls_press_date> ----> IN CORRECT FORMAT <Author/> - <VDKSUMMARY> lorem ipsum fsdfksdfhsdfsdfsdfsdfs dfdfksdfsdfsdfhsdfksdf dfsdfsdfsfj ksdfdsfsdfdfdjklsfsdgfsdfsd </VDKSUMMARY> <score>1.0000</score> <rls_press_release>press_release</rls_press_release> <Subject/> <rls_headline>fsdfksdf hsdf sdfsdf sdfs</rls_headline> <rls_date_string>02 March 2009</rls_date_string> </rs> Correct format: <rs constraints="no-constraints" hit="3" locale="en" name="5157.htm" project="corp"> <locale>en</locale> <type>HTML</type> <name>5157.htm</name> <released>true</released> - <guid> standardcontentimpl-ab3293a-11ab8d1849a-9480e52b9ba4d39 </guid> <group>/media_centre/press_releases</group> <description/> <last-updated>2009-03-02 03:28:51.14</last-updated> - <context> df sdf sdf </context> - <title> and asfd </title> <Size>1346</Size> <rls_mod_date/> <rls_title>Press Release heading</rls_title> <fielddate/> <MIME-Type>text/html</MIME-Type> <Date/> <Modified/> <rls_date>2009/03/02 00:00:00</rls_date> <size>1346</size> <Title/> <rls_press_date_string>28/6/2006</rls_press_date_string> <fieldcontenttitle/> <rls_teaser/> <rls_searchable/> <rls_press_date>2006/06/28 00:00:00</rls_press_date> ----> CORRECT FORMAT <Author/> - <VDKSUMMARY> sdf jksdfhsdfhk lsd </VDKSUMMARY> <score>1.0000</score> <rls_press_release>press_release</rls_press_release> <Subject/> - <rls_headline> fsdn fdn </rls_headline> <rls_date_string>02 March 2009</rls_date_string> </rs> Below is the Query being fired : <rde-dm:query-verity> ( (CIS_GROUP <CONTAINS> press_releases) ) <AND> (rls_press_date >= 2006-06-01) <AND> (rls_press_date < 2006-7-01) <AND> (<not> rls_searchable = false) </rde-dm:query-verity> - <rde-dm:query-cis> ( (CIS_GROUP <CONTAINS> press_releases) ) <AND> (rls_press_date >= 2006-06-01) <AND> (rls_press_date < 2006-7-01) <AND> (<not> rls_searchable = false) </rde-dm:query-cis> Please suugest me what could be the problem. Regards, Chandrakanth Ramireddy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/RedDot-CMS-Users?hl=en -~----------~----~----~----~------~----~------~--~---
