create a date difference generatedfield in model

Using Django Using the ORM
22

It would be more helpful if you copy/pasted a couple of the actual lines from the file so that I can see the actual data being uploaded.

23

sorry for the delay. Had to re-create the issue.
Here is the raw data from Excel (CSV)

Exam_Event Exam Type Exam_Start_Date Exam_End_Date
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
71640 HCSR 3/1/2023 8/31/2023
70058 HCSR 3/1/2022 8/31/2022
70058 HCSR 3/1/2022 8/31/2022
70058 HCSR 3/1/2022 8/31/2022
70058 HCSR 3/1/2022 8/31/2022
70058 HCSR 3/1/2022 8/31/2022

Once I load into the backend Sqlite3, i can see the date values:

image
image917×635 123 KB

But from Django Admin page, the dates are blank:

image
image795×539 49.1 KB

I had to manually enter the start and end dates after some research. But I am looking for a more sustainable solution that will allow me to load larger datasets and not worried about manually enter the date values.

24

What does the schema look like for that table in sqlite?

What is your model definition for the Exam model?

What does the actual input data look like? (Not the representation from sqlite and not the representation from Excel. It would be helpful to see the actual data.)

What I’m guessing is that this is being imported as a CharField and not as a date field.

25

in my examination model, the dates are datetimefield.

class Examination(models.Model):
    Exam_ID = models.CharField(max_length=255, primary_key=True, auto_created=True)
    Exam_Name = models.CharField(max_length=255)
    Bank = models.ForeignKey(Bank, on_delete=models.CASCADE, related_name='Exam')
    Exam_Event_ID = models.CharField(max_length=255)
    Exam_Type = models.CharField(max_length=255)
    Exam_Start_Date = models.DateTimeField(blank=True, null=True)
    Exam_End_Date = models.DateTimeField(blank=True, null=True)
    Exam_Scope = models.CharField(max_length=255)
    Exam_Rating= models.CharField(max_length=255)

Here's the table schema:

0|Exam_ID|varchar(255)|1||1
1|Exam_Name|varchar(255)|1||0
2|Exam_Event_ID|varchar(255)|1||0
3|Exam_Type|varchar(255)|1||0
4|Exam_Start_Date|datetime|0||0
5|Exam_End_Date|datetime|0||0
6|Exam_Scope|varchar(255)|1||0
7|Exam_Rating|varchar(255)|1||0
8|Bank_id|varchar(10)|1||0