I have field periodDate in this format: 01/01/2001, day/month/year). How can I transform this field become a date field and apply the year() or quarter() functions?
try going to settings->admin->table metadata and from there click the gear on the specific field. You might be able to transform that field (which I think it's saved as a string right?) to a datetime