I have a form which takes a date time entry. I now need to write a SQL query to check for overlap as a validation but have just discovered that the data type is longtext. Does anyone have any suggestions for how to do a date query in this context? We are dealing with less than 1000 entries.

How to write date queries against gravity form longtext gf_entry_meta

chrishajer (Chris (Gravity Forms)) October 3, 2022, 4:13am 4

It looks like you created a new topic after getting a little further, so we will continue here:

Topic		Replies	Views
Check for overlapping datetime Get Help custom , gform_field_validation , date	5	480	October 3, 2022
How to create a field filter for a date time field Get Help gfapi , date-field , database	1	410	October 30, 2022
Searching entries with Regex Get Help gfapi , regex , search , get_entries , search_criteria	2	387	March 8, 2023
How do I find the correct meta key of a field [RESOLVED] Get Help get_entries	3	919	January 23, 2023
Including a date range in V2 REST API search criteria Get Help rest-api , date-range	12	2495	January 4, 2022