i have two columnns

start date : end date
01/01/2012:02/01/2012
02/01/2012:03/01/2012
03/01/2012:04/01/2012

how do i use the end date as my start date? the given data is only the end date.

correction. the 01/01/2012 and 04/01/2012 dates are not given... the rest are.

Hi caierhui,

I don't really get your question. What exactly do you want to do and in what context?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.