Thanks guys....the single quote works!!!!!!!!! So glad:) Love this forum!:-D

Btw guys i am wrapping up my work after this. I am asked to prepare for a rerun scenario. I have...

Oh i tried using msgbox to see...

John Mitchell-245523 (1/3/2013)

---

What is the "+':00'" at the end for? If you're trying to append ":00" on to the end of a number, you need to do...

How do i do this?

From what i see, phil your solution will definitely...

Hi satish,

I tried out your solution, it does not met my requirement. I guess your solution take 73 hrs before my current sys date time. This...

Thanks! 😀

Thanks to both of you, currently out of office cant test our both solutions. Will test as soon as i get back. Btw from what i read from both your...

Phil Parkin (12/27/2012)

---

10e5x (12/27/2012)

---

You are right, definately will have overhead. i try to get it done first before looking at efficiency issue. Actually my problem is defining startDate and endDate....

You are right, definately will have overhead. i try to get it done first before looking at efficiency issue. Actually my problem is defining startDate and endDate. Thanks phil

Its Oracle View

Hi Phil,

Once again thanks for replying and helping. Ya my source it is from RDBMS. Your suggestions are too complicated to me. I am trying some other simpler way. Maybe...

Thanks got it! I will paste

into a notepad i do the necessary.

Hi Churlbut,

Thanks for replying, wasnt expecting that but this really explain why this forum is so good.

This is my first time working with batch file or cmd file. I dont...

Hi all,

Firstly, I sincerely want to THANK EVERYONE who have been helping me all these while, especially to those who put in a lot effort to guide me. Finally i...