Skip to main content

Questions tagged [dates]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
76 views

date_format no longer works with Smarty 3 in messages

Since I enabled Smarty 3 under CiviCRM 5.72, the messages containing dates followed by the |date_format:"%e/%m/%Y" modifier cause next error message to occur: There has been a critical ...
Pierre François's user avatar
1 vote
1 answer
22 views

Change date contribution or membership offers date of day but 10 years ago

We are facing a very strange problem. At the time of resuming a contribution or changing an end date, today we cannot choose a date beyond 2014. Automatically the date of the day fills the 3 fields ...
Alain Rihs's user avatar
0 votes
0 answers
19 views

Chronological List of Events

Please can we have our list of events in chronological order, currently they are in reverse chronological order. I have tried clicking the Start Date but it only turn that page of events up the other ...
Giselle Thornton's user avatar
3 votes
2 answers
339 views

How to calculate number of days to/from a date

In a SearchKit query I'm looking to add a column that tells me the number of days from today to/from a date field. Basically datediff() from today. If the date is in the future, say tomorrow, the ...
Justin657's user avatar
  • 365
1 vote
0 answers
21 views

How do we disable pop up calendar on required date field in event registration?

About 25% (?) of our event registrants are screwing up the year portion of pop-up calendar. We see no way to disable the pop-up calendar graphic on date fields regardless of date format (yyyy-mm-dd) ...
Keith Jarvis's user avatar
1 vote
1 answer
65 views

Search Kit - rewrite date to display one week earlier

How can I rewrite the date in search kit so that it displays a date '7 days prior'? Field is [start_date] of an event. One week before is the deadline for submissions. I just want to display that ...
shibetpc's user avatar
5 votes
1 answer
563 views

How can I change the date format in a Search Kit result?

I have a Search Kit search that shows the date like this: November 1st, 2012 12:00 AM. I want to reformat this as 11/01/22. How can I do this?
Jon G - Megaphone Tech's user avatar
1 vote
1 answer
137 views

Default value for custom date field

My CiviCRM 5.56.1 runs on Drupal 7. I try to set the default value for a custom field which is used for an Action. I created the field in Admin -> Customized Data & Screen -> Custom Fields. ...
Pál Rudan's user avatar
0 votes
1 answer
17 views

Activity import gets the century wrong

When I import activities from a CSV using a date format that includes a 2-digit year (for example, mm/dd/yy), dates such as "01/18/22" get imported as January 18, 1922 instead of January 18, ...
Noah Miller's user avatar
  • 1,057
2 votes
1 answer
40 views

Webform CIVICRM Date List and Date/Time doesn't capture year correctly

I'm using CIVICRM Webform on Drupal 9, I'm trying to capture some date fields using Date List and or Date/Time, instead of the regular Date field, because of some strange issues on older browsers, (...
Craig Creque's user avatar
2 votes
1 answer
32 views

Is it possible from web interface to export Notes' dates?

We are attempting to download all details on some of our donors, including the notes, but do not see among the fields to be exported the date of Notes. We can export the Note itself, but no details ...
Tony Fleming's user avatar
0 votes
1 answer
17 views

How can I adjust the date widget on Reports

The birth date widget on Reports such as the Constituent Detail seems hard coded to allow only dates within the last 20 years. How do I adjust this?
Laryn's user avatar
  • 8,268
6 votes
2 answers
312 views

Event on several different days

I want to create an event in CiviCRM: The event takes place on 8.10., 9.10. and 16.10. So this is an event with three sessions (not an repeating single event). The participants can not book a session ...
Michael's user avatar
  • 61
2 votes
1 answer
18 views

making Registration End date relative

I frequently have a problem when using CiviEvent that registration is not live because of problems with the end (or start and end) dates. Often this is caused by: An event I copy and edit. Repeating ...
TimETown's user avatar
  • 373
4 votes
1 answer
133 views

Date in English even when page is set to french

My site is multilingual (English and French) and built on WordPress. I have an event page which is translated. I get the right page version when I use lcMessages=(en_CA|fr_CA) in the URL. However, the ...
kapn's user avatar
  • 919
0 votes
0 answers
14 views

Profile edits change dates on historic information

This client runs an urban gleaning program, harvesting fruit from residential trees and providing fruit to low income communities. A key piece of data is how much fruit is donated from each tree owner ...
LyonsDigital's user avatar
3 votes
2 answers
95 views

Contact Import German Date Format support?

CiviCRM 5.20.2/WP: My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy). How can I get ...
Bertl's user avatar
  • 131
4 votes
1 answer
103 views

How to create new Relative Date Filter?

I've stumbled across the options in Administer - System Settings - Option Groups and I read somewhere that you can create new ones.. so I tried using the syntax of existing options: eg Previous 2 ...
Robinnz's user avatar
  • 403
2 votes
0 answers
62 views

How to change the date format for a mailing token for a custom date field [duplicate]

We have a date field, custom, set to be dd-mm-yyyy but when we add a token for that custom field in a mailing it comes out as yyyy-mm-dd hh:mm:ss How do we change this
petednz - fuzion's user avatar
  • 28.4k
3 votes
1 answer
54 views

How to suppress translation of months (or all fields) in receipts?

My platform: CiviCRM 5.16.3 on Drupal 7.6.7 PHP 7.2 CentOS 7. Drupal language is English. CiviCRM l10n installed and selected my own languange zh_TW Chinese(Taiwan). At receipt print-outs CiviCRM ...
user9611631's user avatar
0 votes
2 answers
33 views

Contact reminder

I have entered a contact in Civi. I want to reminder myself to contact her in a year. I don't have administer privileges. I can't find anything within the contact to let me do this.
Phillip Money's user avatar
1 vote
1 answer
52 views

Where do I change the due date for event invoices and can I set a fixed date instead of a variable date?

In our case, the invoices are being sent with each "pay later" event registration. The default appears to be 10 days. The client wants to change the date to September 3 of this year. Do I need a new ...
LyonsDigital's user avatar
1 vote
1 answer
77 views

Edit birth date

I have setup a webform to register people to an event, which we need to collect DOB. I have included the Birth Date field in the CiviCRM webform. One person can register multiple people. If they do ...
Ben's user avatar
  • 353
0 votes
0 answers
49 views

Date picker stuck at 1970

We recently updated CiviCRM to 5.13.5 and have noticed that the date picker for memberships and relationships have stopped working. It is working for events and other areas. Can anyone help please.
Sohal Khatwani's user avatar
5 votes
1 answer
64 views

How to approach fuzzy dates (e.g. contact deceased in month/year)?

I was posed this question recently and wonder how others would approach this issue: We often are told someone died in (for example) December 2018, but no day. The system won't let me enter it ...
Laryn's user avatar
  • 8,268
1 vote
0 answers
24 views

Issue updating multiple contributions

The date field seems to break when trying to update multiple contribution dates. Drupal 7, Civi 5.10.4 and 5.11, Shoreditch enabled or disabled. Also happens to break the Menu, KAM, Shoreditch, or ...
themak's user avatar
  • 3,441
3 votes
4 answers
848 views

How to change the date format for the receipt date in a template

I'm using the "Thank-you letters - print or email" functionality to generate a receipt for contributions. I created a new template with all the information needed. However we have a problem to display ...
Davum's user avatar
  • 71
3 votes
2 answers
34 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 ...
Bruno  Vincent's user avatar
1 vote
1 answer
260 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?
Bruno  Vincent's user avatar
2 votes
1 answer
47 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 ...
Bruno  Vincent's user avatar
0 votes
0 answers
172 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 ...
Phil Morice Brubaker's user avatar
2 votes
1 answer
365 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....
Phil Morice Brubaker's user avatar
4 votes
0 answers
127 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 ...
naomi's user avatar
  • 1,247
5 votes
2 answers
430 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 ...
Laryn's user avatar
  • 8,268
1 vote
0 answers
45 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 ...
Matt Muchowski's user avatar
2 votes
1 answer
32 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 ...
markusk's user avatar
  • 137
3 votes
1 answer
67 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"). ...
Phil Morice Brubaker's user avatar
0 votes
1 answer
84 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 ...
fdarn's user avatar
  • 127
2 votes
1 answer
38 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 ...
Kboy's user avatar
  • 1,116
3 votes
2 answers
45 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 ...
Phil Morice Brubaker's user avatar
3 votes
1 answer
33 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?
Laryn's user avatar
  • 8,268
1 vote
2 answers
74 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, ...
A. Block's user avatar
  • 555
1 vote
1 answer
47 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 ...
universalhandle's user avatar
3 votes
1 answer
83 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 > ...
user1147171's user avatar
2 votes
0 answers
49 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 ...
Leisa TFA's user avatar
3 votes
1 answer
90 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 ...
pmoz's user avatar
  • 1,821
1 vote
1 answer
40 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 ...
Jason's user avatar
  • 13
2 votes
1 answer
57 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 ...
Andy Clark's user avatar
  • 4,845
2 votes
0 answers
30 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/...
Rob Squires's user avatar
2 votes
3 answers
473 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 ...
Jamie's user avatar
  • 1,246