LastLogon date in different formats per record

[Guest]

I am doing a last logon export for about 40,000+ users, and I see that sometimes the Lastlogon value comes in as MM/DD/YYYY and sometimes is comes as DD-MM-YYYY. Shouldn't the export covert the UTC value to a date? Does the local setting the on the DOmain Controller influence the final value from the export?

[cmccullough]

Re: LastLogon date in different formats per record

I believe it would be based on the settings on the computer running Exporter. Are you seeing differences within the same export, or when running from different computers?

[Guest]

Re: LastLogon date in different formats per record

The same machine is showing differences.

One record in particular is showing a date format of MM-DD-YYYY
and the next record is DD-MM-YYYY.

It's causing from problems because I take that export and throw it into Oracle, and the date format is killing me.

[kstanush]

Re: LastLogon date in different formats per record

send a sample of this output to [email protected]

Thanks