Missing Date Field Type Blocking VAT Calculations in Custom Zoho CRM Module

Missing Date Field Type Blocking VAT Calculations in Custom Zoho CRM Module

I'm working on a custom VAT calculator within Zoho CRM where I need to store the purchase date of a product and calculate VAT based on that date, since VAT rates can vary over time. However, while creating custom fields, the only available data type is "Text Box (Single Line)", and there's no option to select a proper Date field. This is causing issues in setting up workflows and formula fields that depend on the purchase date. Due to this limitation, I'm unable to automate VAT calculations accurately based on dynamic date logic.