Answers.Body: <p>There was a small bug introduced in the last version where the calendar icon didn't show up in search builder date fields, but the actual datepicker still works fine.</p>
  
  <p>The screenshots and videos are misleading, as they use <em>Contact:Created Date</em> as the example field - this is actually <em>not</em> a date field (despite the name) it is a <em>Timestamp</em> which doesn't work with the datepicker widget, unfortunately, so I don't believe this is a regression.</p>
  
  <p>Edit: I stand corrected. Previous versions <em>did</em> provide a datepicker for timestamp fields, however it didn't work very well since it didn't allow you to specify time. I've created a fix to restore the datepicker and add a timepicker for those fields: <a href="https://github.com/civicrm/civicrm-core/pull/13249" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/13249</a> </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T19:18:21.547Z
Answers.Text: Thx Coleman - can you clarify. The screenshot in my answer shows there was a Calendar picker in 5.3.1 that worked but you seem to be saying it doesn't work with a datepicker widget. - i added more images to my answer
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T20:55:30.500Z
Answers.Text: Err, I guess it sort of works, except it won't with the `=` operator as the date entered is less precise than the timestamp. Maybe for timestamp fields we should be presenting a date+time widget for clarity.
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T21:14:44.383Z
Answers.Text: Ok I think I've fixed it! Datepicker now works on both Date and Timestamp fields!
  https://github.com/civicrm/civicrm-core/pull/13249
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T14:37:35.503Z
Answers.LastActivityDate: 2018-12-11T13:16:54.333Z
Answers.LastEditDate: 2018-12-11T13:16:54.333Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>This is what i am seeing on dmaster compared to a 5.3.1 site</p>
  
  <p><a href="https://i.sstatic.net/AXdWs.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/AXdWs.png" alt="enter image description here"></a></p>
  
  <p>seems like a regression. needs an issue opening.</p>
  
  <p>More from 5.3.1</p>
  
  <p>The datepicker in action</p>
  
  <p><a href="https://i.sstatic.net/8RXMu.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8RXMu.png" alt="enter image description here"></a></p>
  
  <p>and the outcome</p>
  
  <p><a href="https://i.sstatic.net/vUVBu.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vUVBu.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T04:46:56.363Z
Answers.Text: Will I raise the issue or will you do that?
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-10T00:58:36.863Z
Answers.LastActivityDate: 2018-12-10T19:18:10.487Z
Answers.LastEditDate: 2018-12-10T19:18:10.487Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I am running Drupal 7.61 and CiviCRM 5.8.0. I have recently upgraded from 5.3.1 and when I use search builder to locate contacts using created date the date picker does not display. (See attached video link). If I use search builder to find an individual using their birth date the date picker functions correctly.</p>
  
  <p>I have not made any configuration changes to CiviCRM in the upgrade process.</p>
  
  <p><a href="https://drive.google.com/file/d/1eEcirO-AWDk6o2ddIFBhkQ6GuOJQIkPF/view?usp=sharing" rel="nofollow noreferrer">Video showing date picker issue</a></p>
  
  <p><a href="https://drive.google.com/file/d/1jALyk2SSUR29GM1YUWXRwe4AF6GT3WL5/view?usp=sharing" rel="nofollow noreferrer">Screenshot from Demo Site</a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-09T22:30:32.503Z
Comments.Text: seems not to pop-up for Date Received for Contribution either on dmaster.demo.civicrm.org - also i compared with a 5.3.1 site and not seeing date picker there so not sure if you are suggesting this is a regression or not, but i suggest it is not..
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-09T23:35:23.267Z
Comments.Text: It worked fine on 5.3.1 - I used it every day to locate Contacts created after a certain Created Date and it worked just fine. It does work if you search for an Individual's Birth Date.
Comments.UserDisplayName: Martin Fuggle
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-10T00:13:04.990Z
Comments.Text: but Birth Date works on https://dmaster.demo.civicrm.org/civicrm/dashboard if you click in the date cell you get a calendar
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-10T00:28:55.060Z
Comments.Text: No it doesn't - I will add a link to the relevant page in the demo site (which is running 5.10.alpha1 and in Spanish which is not my first language!) in the original post and it shows that the date picker does not display. In fact it operates exactly as in my installation of 5.8.0.
Comments.UserDisplayName: Martin Fuggle
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-10T00:59:20.877Z
Comments.Text: my apologies - i skim read and thought you were saying that it also didn't work on birth date.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-10T04:52:56.393Z
Comments.Text: I also misread stuff, this time in Peter's comment above. Individual Birth date works OK on 5.3.1 and 5.8.0. It is Contact's Created Date that works on 5.3.1 but not on 5.8.0 as shown in Peter's answer below.
Comments.UserDisplayName: Martin Fuggle
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-10T21:30:47.823Z
Comments.Text: Martin - open a ticket if you want us to patch on your site so you can QA
Comments.UserDisplayName: petednz - fuzion
Tags: <search-builder>
Title: Search builder does not display date picker for contacts
ThreadText: # Search builder does not display date picker for contacts
  
  (Asked by: username_0 on 2018-12-09)
  
  I am running Drupal 7.61 and CiviCRM 5.8.0. I have recently upgraded from 5.3.1 and when I use search builder to locate contacts using created date the date picker does not display. (See attached video link). If I use search builder to find an individual using their birth date the date picker functions correctly.
  
  I have not made any configuration changes to CiviCRM in the upgrade process.
  
  [Video showing date picker issue](https://drive.google.com/file/d/1eEcirO-AWDk6o2ddIFBhkQ6GuOJQIkPF/view?usp=sharing)
  
  [Screenshot from Demo Site](https://drive.google.com/file/d/1jALyk2SSUR29GM1YUWXRwe4AF6GT3WL5/view?usp=sharing)
  
  **Tags:** search-builder
  
  > **Comments:**
  > **username_1**: seems not to pop-up for Date Received for Contribution either on dmaster.demo.civicrm.org - also i compared with a 5.3.1 site and not seeing date picker there so not sure if you are suggesting this is a regression or not, but i suggest it is not..  
  > **username_0**: It worked fine on 5.3.1 - I used it every day to locate Contacts created after a certain Created Date and it worked just fine. It does work if you search for an Individual's Birth Date.  
  > **username_1**: but Birth Date works on https://dmaster.demo.civicrm.org/civicrm/dashboard if you click in the date cell you get a calendar  
  > **username_0**: No it doesn't - I will add a link to the relevant page in the demo site (which is running 5.10.alpha1 and in Spanish which is not my first language!) in the original post and it shows that the date picker does not display. In fact it operates exactly as in my installation of 5.8.0.  
  > **username_1**: my apologies - i skim read and thought you were saying that it also didn't work on birth date.  
  > **username_0**: I also misread stuff, this time in Peter's comment above. Individual Birth date works OK on 5.3.1 and 5.8.0. It is Contact's Created Date that works on 5.3.1 but not on 5.8.0 as shown in Peter's answer below.  
  > **username_1**: Martin - open a ticket if you want us to patch on your site so you can QA  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2018-12-10. Score: 3
  
  There was a small bug introduced in the last version where the calendar icon didn't show up in search builder date fields, but the actual datepicker still works fine.
  
  The screenshots and videos are misleading, as they use *Contact:Created Date* as the example field - this is actually *not* a date field (despite the name) it is a *Timestamp* which doesn't work with the datepicker widget, unfortunately, so I don't believe this is a regression.
  
  Edit: I stand corrected. Previous versions *did* provide a datepicker for timestamp fields, however it didn't work very well since it didn't allow you to specify time. I've created a fix to restore the datepicker and add a timepicker for those fields: <https://github.com/civicrm/civicrm-core/pull/13249>
  
  > **Comments:**
  > **username_1**: Thx username_2 - can you clarify. The screenshot in my answer shows there was a Calendar picker in 5.3.1 that worked but you seem to be saying it doesn't work with a datepicker widget. - i added more images to my answer  
  > **username_2**: Err, I guess it sort of works, except it won't with the `=` operator as the date entered is less precise than the timestamp. Maybe for timestamp fields we should be presenting a date+time widget for clarity.  
  > **username_2**: Ok I think I've fixed it! Datepicker now works on both Date and Timestamp fields! https://github.com/civicrm/civicrm-core/pull/13249  
  
  ---
  
  ### Answer by username_1 on 2018-12-10. Score: 1
  
  This is what i am seeing on dmaster compared to a 5.3.1 site
  
  [![enter image description here](https://i.sstatic.net/AXdWs.png)](https://i.sstatic.net/AXdWs.png)
  
  seems like a regression. needs an issue opening.
  
  More from 5.3.1
  
  The datepicker in action
  
  [![enter image description here](https://i.sstatic.net/8RXMu.png)](https://i.sstatic.net/8RXMu.png)
  
  and the outcome
  
  [![enter image description here](https://i.sstatic.net/vUVBu.png)](https://i.sstatic.net/vUVBu.png)
  
  > **Comments:**
  > **username_0**: Will I raise the issue or will you do that?  
  
  ---
  
  