CODEWITHSUNDEEP
virtualdatediffdjango-generatedfield
Mikal025
Mikal025

Reputation: 1

create a date difference generatedfield in model

I want to create a generatedfield that stores the # of days between today and another date field in my model. Currently I have the following:

class Orders(models.Model):
`Order_ID = models.CharField(max_length=10, primary_key=True)`
`Order_Desc = models.CharField(max_length=100)`
`Order_Type = models.CharField(max_length=100)`
`Order_Status = models.CharField(max_length=50)`
`Date_Received = models.DateField()`
`Order_Owner = models.CharField(max_length=50)`
`Days_In_Queue = models.GeneratedField(expression=ExpressionWrapper(Cast(Now(),output_field=models.DateField()) - F('Date_Received'), output_field=models.IntegerField()), 
output_field=models.IntegerField(),
db_persist=True,                                      
)`

However I'm getting the following when I tried to import data into sqlite db.

Error: unknown function:django_timestamp_diff()

Can someone please help with this? If there's a better way, please share.

Thanks.

Upvotes: 0

Views: 11

Answers (0)

Related Questions