Convert string date

[Former Member]

Dear experts.

How can I transfer a string date into string date of previous year, Ex: 24.10.2008 into => 24.10.2007

Thanks for your reply

Huynh Kim Binh

[Former Member]

Hi,

You can convert the string into date using function DVAL(<String>);

You can mainupulate date using function DADD(<date>,<int num of years>,'Y');

Regards,

Murtuza

[Former Member]

Hi

I got a solution, fomular is: DSTR(DADD(STORE@Date,-1,'Y'),"DD.MM.YYYY")

Thanks

HKBinh

Edited by: Huynh Binh on Oct 25, 2008 5:17 AM

[lanzlf]

Hi Huynh,

You might try with a kind of formula

Best Regards,

Luis