We are using Verity K2 server and Live server 4 and RedDot CMS 7.5. Regards, Chandrakanth Ramireddy
On Mar 2, 10:12 am, Chandrakanth Ramireddy <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
