CSVDE Dates in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D-a-n_L - 26 Oct 2004 23:17 GMT

How do I convert the Active Directory formatted dates exported by CSVDE when
viewing in Excel to a readable format?

Reply to this Message

Al Mulnick - 27 Oct 2004 01:06 GMT

http://groups.google.com/groups?hl=en&lr=&threadm=%23msiz%23Z8DHA.3804%40tk2msft
ngp13.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3Dldifde%2B%2522date%2Bf
ormat%2522%26btnG%3DSearch

You may have some luck with the dsquery tools by sending the output to a
text file. I haven't checked to see if it converts for you or not though.

Al

> How do I convert the Active Directory formatted dates exported by CSVDE
> when
> viewing in Excel to a readable format?

Reply to this Message

D-a-n_L - 27 Oct 2004 14:52 GMT

It never ceases to amaze me how Microsoft or other vendors for that case can
pump out pounds of code that is very useful and quality yet can overlook
such a simple thing like making an extracted field easily readable by the
masses?

http://groups.google.com/groups?hl=en&lr=&threadm=%23msiz%23Z8DHA.3804%40tk2msft
ngp13.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3Dldifde%2B%2522date%2Bf
ormat%2522%26btnG%3DSearch

> You may have some luck with the dsquery tools by sending the output to a
> text file. I haven't checked to see if it converts for you or not though.
[quoted text clipped - 4 lines]
> > when
> > viewing in Excel to a readable format?

Reply to this Message

Al Mulnick - 28 Oct 2004 01:40 GMT

I suppose since most people don't look at those (you've been doing this a
while and are just now getting to it, am I right?) they figured putting it
in .NET would be enough.

I could be wrong though.

Al

> It never ceases to amaze me how Microsoft or other vendors for that case
> can
[quoted text clipped - 13 lines]
>> > when
>> > viewing in Excel to a readable format?

Reply to this Message

D-a-n_L - 28 Oct 2004 15:15 GMT

True...

> I suppose since most people don't look at those (you've been doing this a
> while and are just now getting to it, am I right?) they figured putting it
[quoted text clipped - 9 lines]
> > such a simple thing like making an extracted field easily readable by the
> > masses?

http://groups.google.com/groups?hl=en&lr=&threadm=%23msiz%23Z8DHA.3804%40tk2msft
ngp13.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3Dldifde%2B%2522date%2Bf
ormat%2522%26btnG%3DSearch

> >> You may have some luck with the dsquery tools by sending the output to a
> >> text file. I haven't checked to see if it converts for you or not
[quoted text clipped - 5 lines]
> >> > when
> >> > viewing in Excel to a readable format?

Reply to this Message