{"id":280,"date":"2010-12-06T13:05:00","date_gmt":"2010-12-06T13:05:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=280"},"modified":"2023-07-03T09:58:59","modified_gmt":"2023-07-03T09:58:59","slug":"date-ing-tips","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/","title":{"rendered":"\u201cDate\u201d ing Tips"},"content":{"rendered":"

In my earlier post, I had explained how to retrieve date format of currently logged in user in SageCRM.
\nhttp:\/\/sagecrmaddons.blogspot.com\/2009\/02\/retrieve-current-logged-in-users-date.html<\/a><\/p>\n

There have been numerous instances where the user needs a custom list page with the filter box and the standard way of doing this by using an existing filter screen. However the hitch here is that we have to take care of the filter button ourselves which means that once the user clicks on the filter button we have to generate the criteria to and pass this criteria to the list so that it shows only those set of records that meet the filter criteria.<\/p>\n

The below section would slightly tend to curve on the technical side but I will try and keep it as \u201cstraight\u201d as possible. You see, in case of lookup field in filter box there is no \u201ccontains\u201d or \u201cstarts with\u201d operator to search the records. You simply have to search whatever has been set in the lookup value and get the records to display in the list. But if the field in the filter box is a date field like a created date etc then it\u2019s not so easy because with the date field Sage CRM provides a list of operators like between, relative etc as well.<\/p>\n

Let me explain with an example. Suppose you have added Created Date (oppo_createddate) field in Custom filter box. Here the problem is to find the control name where the entry of options Between and Relative goes.<\/p>\n

\"Date<\/a><\/div>\n

Well, DateTimeModesoppo_createddate control is created on the screen when you are adding the Date fields in filter box. Depending upon the value (Between\/Relative) and reading the values of oppo_createddate_start and oppo_createddate_end, you can pass the same with custom filter criteria in an ASP page for filtering the list. While appending filter criteria you need to check user date format in your ASP page. The same is applicable for other date fields like Opened, Close By, Closed. The key here is to read the value and generate a correct SQL statement so that the right data in being displayed in the list.<\/p>\n

So be in real world or Sage CRM you need to be well prepared for a date.<\/p>\n

Note: <\/strong>Please click the images to enlarge them.
\nFor queries regarding the functionality, please feel free to drop us an email at crm@greytrix.com<\/a>. <\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

In my earlier post, I had explained how to retrieve date format of currently logged in user in SageCRM. http:\/\/sagecrmaddons.blogspot.com\/2009\/02\/retrieve-current-logged-in-users-date.html There have been numerous instances where the user needs a custom list page with the filter box and the standard way of doing this by using an existing filter screen. However the hitch here is\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332],"tags":[611,928,1905],"class_list":["post-280","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-between","tag-datetime","tag-relative"],"yoast_head":"\n\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In my earlier post, I had explained how to retrieve date format of currently logged in user in SageCRM. http:\/\/sagecrmaddons.blogspot.com\/2009\/02\/retrieve-current-logged-in-users-date.html There have been numerous instances where the user needs a custom list page with the filter box and the standard way of doing this by using an existing filter screen. However the hitch here is\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-06T13:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-03T09:58:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/\",\"name\":\"\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg\",\"datePublished\":\"2010-12-06T13:05:00+00:00\",\"dateModified\":\"2023-07-03T09:58:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage\",\"url\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg\",\"contentUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u201cDate\u201d ing Tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/","og_locale":"en_US","og_type":"article","og_title":"\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In my earlier post, I had explained how to retrieve date format of currently logged in user in SageCRM. http:\/\/sagecrmaddons.blogspot.com\/2009\/02\/retrieve-current-logged-in-users-date.html There have been numerous instances where the user needs a custom list page with the filter box and the standard way of doing this by using an existing filter screen. However the hitch here is\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-12-06T13:05:00+00:00","article_modified_time":"2023-07-03T09:58:59+00:00","og_image":[{"url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/","name":"\u201cDate\u201d ing Tips - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage"},"thumbnailUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg","datePublished":"2010-12-06T13:05:00+00:00","dateModified":"2023-07-03T09:58:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#primaryimage","url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg","contentUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TPzeuVyBFjI\/AAAAAAAABL8\/iHudEdf9lqI\/s320\/clip_image002.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/12\/06\/date-ing-tips\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"\u201cDate\u201d ing Tips"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=280"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/280\/revisions"}],"predecessor-version":[{"id":27230,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/280\/revisions\/27230"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}