I need to extract the year from 0DATE using formula variable in Bex query designer. Date is in format mm-dd-yyyy and I need yyyy. So I am giving offset start - 7 in formula variable (with replacement path on 0DATE). However I am getting garbage value. Can anyone please suggest why this is happening and what is the resolution?