StrtoTime: Allow using a custom date format

Open on Drupal.org →

Created on 17 June 2025, about 1 month ago

Problem/Motivation

There are some date formats that can not be easily resolved with strtotime().

It'd be useful if the user could specify the custom format the date is in so that it can be parsed consistently.

Steps to reproduce

Attempt to convert the date 30/06/2025 23:59:00 into time, it should ideally be parsed as mm/dd/yyyy format, but there's no easy way to parse that currently, except doing a somewhat hacky search and replace of the "/" with "-".

Proposed resolution

It'd be better if the plugin builder can specify the expected format of the date so that certain date formats can be easily converted to a date.

Remaining tasks

Provide issue fork/patch.

User interface changes

There should be a new "Custom date format" option on the plugin page. If it's not set, the previous strtotime() behaviour will be kept.

API changes

N/A

📌 Task

Status

Active

Version

1.0

Component

Code

Created by

Live updates comments and jobs are added and updated live.

Sign in to follow issues

Merge Requests

!48StrtoTime: Allow using a custom date format
Open
codebymikey
updated about 1 month ago

Comments & Activities

Issue created by @codebymikey
Merge request !48Issue #3530530 by codebymikey: StrToTime: Support custom date formats → (Open) created by codebymikey
Pipeline finished with Canceled
about 1 month ago
Total: 533s
#524286
Comment about 1 month ago →
codebymikey
Comment about 1 month ago →
codebymikey
Pipeline finished with Success
about 1 month ago
Total: 853s
#524296
Comment 21 days ago →
🇳🇱Netherlands megachriz
This is a great addition! I do wonder if we should fallback to strtotime() when parsing the date fails. Maybe provide that as an option? "Fallback to strtotime() if the date could not be parsed.". What do you think?

If you have applied the Tamper "String to Unix Timestamp" to the source "date" and set the date format to "d/m/Y" and then import the following CSV:

title,date Foo,2020-09-01 Bar,01/11/2011 Qux,01-10-2011
This is the result after import (using the latest dev releases of Feeds and Feeds Tamper):

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024