Yes just format the 2nd one as following
Dim dt As DateTime
Dim strDt
dt = Format(#2/12/2008 6:00:00 PM#, "dddd, d MMM yyyy hh:m:ss tt ")
strDt = Format(dt, "yyyy-MM-d%T HH:m:ss")
Lue
> Hi Lue,
>
[quoted text clipped - 41 lines]
>> >> > Thanks,
>> >> > Deepak
deepak - 11 Feb 2008 18:27 GMT
yeah lue,its woroking...ur great lue....thanks......Ma i add u in msn ..also
i may have some more questions in the coming hours....Kinldy help me...u
dont know u helped so much in this way .. i can not forget really....:-)
- Deepak
> Yes just format the 2nd one as following
> Dim dt As DateTime
[quoted text clipped - 52 lines]
> >> >> > Thanks,
> >> >> > Deepak