[Therion] Display in legend explo length of a year

Hello, Is there a way to display in a legend of a lookup explo-date the explo length of the relative year? I know how to do it via sql database query but not in tex. And while I’m at it, how can I modify date format of the ‘currentdate’ legend variable?

From YYYY:MM:DD to DD:MM:YYYY for example.

Thanks ! Martin