kirshna bro,

i have a begin date as 20040721152135, is stored in Begintime variable.... 20040721 is a date, 152135 is time. I want to make a variable such that 20040721 is sepeareted.

=ToDate([Begintime];"yyyyMMdd") but it gives error because we have not spacified in our formula here what 152135 is, how do i make it work.

btw i really appriciate you helping me out with this. I am interning and there is no outside help.