Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Variable v_Date 31-01-2015 & I want to show v_Date1 as (v_date-30 days)
in input box .
Vikas
Try this:
=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')
Try this:
=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')
Or this for 30 days:
=Date(Date#(v_Date, 'DD-MM-YYYY') - 30,'DD-MM-YYYY')
thnx