Django DateTimeRangeField how to filter by lower only?

Question

Let's say I have a model with the DateTimeRangeField, and I would like to filter by the lower bound greater than now(), regardless whatupper bound is:

BackupResource.objects.filter(datetime_range__lower__gt=timezone.now())

It errors out:

Unsupported lookup 'lower' for DateTimeRangeField or join on the field not permitted.

score 2 · Accepted Answer · answered May 08 '19 at 23:04

2

Try doing the following

BackupResource.objects.filter(datetime_range__startswith__gt=timezone.now())

answered May 08 '19 at 23:04

NS0

6,016
1
15
14

Django DateTimeRangeField how to filter by lower only?

1 Answers1