hi masters,
I have a problem regarding date mapping. How can I add 1 day to a given date. For example, I have a 20090630 date. That's June 30, 2009. How can I add 1 day to it so that the resulting value will be 20090701? If I just use 'add constant 1', the resulting value will be 20090631. There's no 31 for June.
Thanks!
regards,
IX