hai everyone how to get last year or last month date?
example input 01/01/10 so the value for last year is 01/01/09 and last month value is 12/01/09 thanks a lot
hai everyone how to get last year or last month date?
example input 01/01/10 so the value for last year is 01/01/09 and last month value is 12/01/09 thanks a lot
CALCDATE (’-1Y’,010110D) will give you 01/01/09
CALCDATE(’-1M’010110D) will give you 01/12/09
my date format is in dd/mm/yy
right !!
thanks a lot buddy !!