DateField to String formatting in QuerySEt

Question

activitylist = sr.activity_set.all()
cell.paragraphs[0].text = activitylist.values_list('activityPlannedStartDate', flat = True)

I am getting an error of: 'in ' requires string as left operand, not datetime.date

cell.paragraphs[0].text is a cell in a predefined table in a docx that I build in Word.

Please help with this TypeError.

Thank you in advance!

Are you looking for this? http://stackoverflow.com/a/2158454/1486443 — Najera, Jan 21 '15 at 18:49
I am using a DateField: activityPlannedEndDate = models.DateField("Planned End Date") — John Lehrkind, Jan 21 '15 at 18:56

score 1 · Accepted Answer · answered Jan 21 '15 at 19:32

You should use strftime method to format date to string. And use string.join to represent values list as a comma-separated string:

formatted_dates = [date.strftime("%Y-%m-%d") for date in
                         activitylist.values_list('activityPlannedStartDate',
                                                  flat=True)]
cell.paragraphs[0].text = ', '.join(formatted_dates)

score 0 · Answer 2 · answered Mar 30 '20 at 05:58

from django.db.models import F, Func, Value, CharField

qs.annotate(
  formatted_date=Func(
    F('date'),
    Value('dd.MM.yyyy hh:mm'),
    function='to_char',
    output_field=CharField()
  )
)

This works only with a database that supports the to_char date type formatting function. Postgres provides this function by default. If you use a MSSQL backend you could swap to_char with FORMAT. For Oracle consult their documentation, etc.

After the queryset is evaluated this will add the annotation formatted_date to each object in the queryset that is returned.

[obj.formatted_date for obj in qs]

DateField to String formatting in QuerySEt

2 Answers2