Skip to Content
Former Member
Dec 19, 2013 at 01:02 PM

Getting date from 0date using formula variable


Hello gurus,

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?