Implementing a custom Date field to count tickets imported to Zendesk

Hi everyone,

we have recently implemented our activities in Zendesk. Previously, we have stored data manually in an Access App. Gmail was our communication platform.

I have around 50 tickets created in 2020 which I would like to import somehow to Zendesk and integrate the data. We would like to make the rights graphics in Explore. At the moment I do the transfer of tickets and data from Access to Zendesk manually:

1) I forward every email to Zendesk

2) I fill/update the fields manually (from Access to Zendesk).

However, the current date/time is stored automatically in Zendesk. If use metrics based on "ticket created", Explore counts the tickets (per month/year) created in Zendesk System. Therefore I will display above 50 tickets created in Nov 2021 when they created last year.

I have attached a tag to each ticket (month/year) but I think this method might not be reliable in the future. 

Would it make sense to create an additional "date field" within the form? It might be a repetitive process but sometimes we created tickets manually because they are sent directly to our private email accounts.

Does anyone has a solution for my issue?

Best,

Romulo