year :year(`vouchdate` )
season:concat(year(`vouchdate` ), '-Q', quarter(`vouchdate` ))
month:date_format(vouchdate, 'yyyy-MM')
week:concat(year(`vouchdate` ), '-', weekofyear(`vouchdate` ))
day:date_format(vouchdate, 'yyyy-MM-dd')
year :year(`vouchdate` )
season:concat(year(`vouchdate` ), '-Q', quarter(`vouchdate` ))
month:date_format(vouchdate, 'yyyy-MM')
week:concat(year(`vouchdate` ), '-', weekofyear(`vouchdate` ))
day:date_format(vouchdate, 'yyyy-MM-dd')