Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [dates]

The tag has no usage guidance.

3
votes
2answers
29 views

Is there a way to have a “from and to” field , need this for business hours “to and from”

I want to record the working hours from my prospects, so I need a flexible to and from field, like: 9-5, 8-5 etc... I could do drop down selects, but I would rather have it custom, so a double drop ...
0
votes
1answer
15 views

How can I set custom field date field for default date to be today's date?

The threads I have seen are from 2009... Is there a solution for this in 2018? Something that would dynamically set current date as default?
2
votes
1answer
33 views

Date created field displays erratically in views and webform Drupal7 integration

The native date created field for contacts shows up erratically in my views, some items it works, and some it doesn't. The modified date field always displays however. Additionally, there used to be ...
0
votes
0answers
20 views

Help on Contribution import - Invalid value for field(s) : Receive Date

I've recently wanted to add the time to my import of external (non-Civi) transactions. Before this, I just imported the date, which is OK, but the data is there, so why not import it? I keep getting ...
0
votes
1answer
38 views

Custom date field formatting with smarty

I'm trying to format a custom date field using smarty to send emails. What I want is to have the day of the week included, as "Wednesday, April 18, 2018". It seems that this should work: {contact....
3
votes
0answers
32 views

CiviCRM date fields in Drupal views

I want to make a Drupal view showing CiviCRM Relationships and I want to expose the start and end date as exposed filters. I want the user to have a nice GUI for picking the start and end date so I ...
3
votes
2answers
61 views

Searching/filtering by the date a contact was added to a group

When viewing a contact's Group tab, you can see the groups as well as the date that they were added to the group. I've been trying to find a way to search based on the date that a contact was added ...
1
vote
0answers
21 views

Contributions: Received Date Vs. Completed Date?

This might be a little odd. A non-profit I work with is having issues with their contribution reports. They use the stripe extension to process contributions. They run a search weekly for the ...
2
votes
1answer
23 views

Smart Groups and 'event dates'

might there still (or again) be an issue with 4.7.27 on wordpress like this? How to use Smart Groups with relative dates? i'd need to create a dynamic group based on the 'register date' for any ...
3
votes
1answer
50 views

Smart Group relative date criteria not saving

There is a history of a bug in which Smart Groups do not store the proper relative date ("Next 60 days") criteria, but rather convert the relative date into a hard date ("3 Jan 2018" to "4 Mar 2018"). ...
0
votes
1answer
45 views

Setting the date feature is not working in events (Added Screenshots)

I just installed Civi 4.7.27 on Wordpress 4.9.1 in a subdomain. When configuring the new install, I am noticing something strange with the date settings. The first screenshot shows what I am getting ...
2
votes
1answer
26 views

How to disable possibility to enter past date in activities?

I have a custom field of type Date used for activities, even though i have set years prior to current date to 0, it still allows users to select past day and month of the current year. Is there any ...
3
votes
2answers
28 views

Search comparing two date fields

I would like to be able to create a smart group of contacts who: 1) are participants for an event in the future 2) have passport expiration dates (a custom Individual Contact date field) that are ...
3
votes
1answer
28 views

Date of birth — months only show through September

Is anyone else having problems with date of birth only showing through September? I've found this on two different sites. How would I go about debugging this?
1
vote
2answers
47 views

Date picker not appearing in 4.7.23 and Joomla 3.7.5

Not sure what's going on here. Inspecting code for a date field show's right markup (I think), but the date picker doesn't appear on profile date fields on frontend. In backend admin view of profiles, ...
1
vote
1answer
25 views

Date picker separator characters munged

I've a got a local sandbox running CiviCRM 4.7.18 on Drupal. For any datepicker field (e.g., Contacts > New Activity), the selection is displayed with munged URLs separating the date components. For ...
4
votes
1answer
45 views

Is it possible to add just a time as a custom data field for an event?

We want to show multiple dates for the event, each with its own start and stop time. Day 1 Start Time #1 Stop Time #1 Day 2 Start Time #2 Stop Time #2 But in custom data (Administer > ...
2
votes
0answers
37 views

How do I change date display from 2017-03-20 to March 20, 2017?

Writing "Please Renew" letters to membership. Template text includes a token for the expiration date {membership.end_date}. In pdf printout, date converts to number format (yr-mo-day), even though in ...
3
votes
1answer
53 views

How to create a Drupal View that calculates activity end time by duration

I'm trying to create a Drupal View table of CiviCRM activities that calculates the end time of the activity based on start time and duration.So far I've got the unix start time of the activity, a math ...
2
votes
1answer
27 views

Gift Aid Declarations with overlapping dates

I work in the IT department, CiviCrm isn't my forté. I have been tasked with helping the marketing department with a few issues with Civi. One issue that I keep scratching my head about is Gift Aid ...
3
votes
1answer
53 views

Why has entering a date changed in 4.7.16? Can it be reverted?

Entering a date has changed in 4.7.16 so the user can no longer drop down the year in order to select a year in the past. Now they have to scroll through months to go backwards! Imagine entering a ...
3
votes
0answers
25 views

Why are Relative Date filters missing on install?

I did a fresh installation of Civi 4.7.14 with Drupal 7, and have realised that for some reason all the relative date filters are missing. I've been able to add the one I need manually at civicrm/...
3
votes
3answers
217 views

Setting default date value via civicrm_buildForm hook no longer displays date

I have a custom module that invokes the civicrm_buildForm hook to set the default date for a given field to today's date. It is working - in part. When I examine the code I see that the default value ...
3
votes
1answer
39 views

Date confusion with relationships - start date can be later than end date

When adding relationships, I have found that the start date entered can be a later date than the end date of the relationship without any error being indicated. Is this intentional or can I "fix" it ...
3
votes
2answers
33 views

How to extend end date limit for Membership?

When creating/editing membership. End date is limited to 2026 (you cannot choose it in pop-up calendar and if you try to write the date yourself(exceeding the limit) php will not let you do it. which ...
0
votes
1answer
46 views

Name Badge Date Format

In CiviCrm 4.7 Drupal I created a new Name Badge Layout which includes Event End Date. The site language is Italian, so I need the date to be printed as "15 Ottobre 2016", but it comes out as "Ottobre ...
4
votes
1answer
22 views

How can I filter click-through reports by date range?

long time user of civicrm. Have 4.7.6 installed on Drupal 7 in a linux environment and I'd like to look at an old email's metrics. I see I pull up specific URL click-through metrics, but it shows me ...
1
vote
2answers
90 views

Is it a bug that Relative Dates are broken in Search and Smart Groups?

According to CiviCRM user guide article's Searching section The Date Range Filter: Relative date ranges are especially useful for searches that you would like to then save as Smart Groups (...
4
votes
1answer
180 views

How to use Smart Groups with relative dates?

How can I setup a Smart Group to include members based on relative dates (e.g. last Activity)? When I try to use relative date, e.g. Yesterday in advanced search, it correctly finds users with ...
2
votes
2answers
71 views

Can civirules be triggered off a custom field of type date for eg Date equals Now

Client is thinking about several date fields for a contact eg, when are they available to start volunteering' and want an alert for it. My presumption was 'oh let's do it with Activities' but actually ...
6
votes
1answer
80 views

Where are CiviCRM's date preferences actually used?

Under Administer > Customize Data and Screens > Date Preferences, CiviCRM offers a number of date classes for which an administrator can specify date formats. activityDate is described as "Date for ...
2
votes
0answers
24 views

search builder fails with date field in localized civicrm instance

My CiviCRM instance (4.6.11 embedded in Drupal 7.41 in Google cloud) is localized for French language with date format dd/mm/yyyy (31/12/2009). When using a date field in search builder, comparison is ...
2
votes
2answers
203 views

How do I override the default date range of JQuery date widget? [duplicate]

CiviCRM 4.7.3 Currently hard coded to show 10 years in the past, and 9 years in the future. I would like to override this and set the year range from 1965 to the current date, as described in the ...
2
votes
2answers
46 views

How can I disable the JQuery date widget and all just text input?

CiviCRM 4.7.3 Worpdress 4.4.2 Due to issues with the JQuery date widget (e.g. Month and year, or year only formats are not saved and date list only goes back 10 years), I would like to simply disable ...
4
votes
2answers
167 views

How do I allow custom date field over 10 years ago?

Civi 4.7.3 and Wordpress 4.4.2 Since upgrade from 4.7 to 4.7.3 I cannot seem to add a custom date field and allow the user to select a date older than 10 years ago. Recreated on Demo site: Click ...
5
votes
1answer
98 views

Exported custom date fields formatted incorrectly

The error seems to occur during the export process and affects only custom date fields, not those that are built-in. My custom date field is set to use "mm/dd/yyyy", and stores correctly in the sql ...
1
vote
2answers
34 views

Is there an accepted standard for storing data as a year?

To preface this, I'm using CiviCRM's integration on Drupal 7, with the Webform integration module. I'm looking to store a number of custom fields as a year. It appears that I am able to use the Date ...
1
vote
0answers
41 views

Page - specific Datepicker config in jcalendar.tpl

How does one add a default value in one of Datepicker fields while adding or editing Relationship? For example, set today's date as a start date at Enabled checkbox check and as the end date if un-...
6
votes
1answer
177 views

How to set custom relative date filters

I noticed that the relative date filters (e.g. "This week", "Previous quarter) have some new options available in 4.7, and I heard that you can now customize them to create new options. I don't know ...
2
votes
1answer
31 views

How to show Days in Case in Drupal Views?

Trying to create a Drupal View that shows total number of days in a case. There are two methods I'm considering: First, I imagine if I could turn the case start date and end date into "Days Ago" ...
9
votes
1answer
734 views

How do I open a case that started more than twenty years ago?

We have one client whose case started 25 years ago. This falls out of range of the allowable open case date range and produces this message: Is there a way to expand/change this date range?
1
vote
1answer
52 views

Is there a way of recording/exposing when an activity is added to CiviCRM?

When adding a custom activity the current time is automatically shown and can be updated. Where people are adding past/ future activities, is the actual time the activtiy is submitted also recorded ...
6
votes
1answer
249 views

Is it possible to customize the automatic date ranges in Advanced Search?

I was trying to help a group make a simple smart group of all memberships set to expire within the next 2 months and the dropdown for "End date" in the Membership section of Advanced Search only had "...