Adaxes

Export Report to XLSX, date problem

0 votes

Hello

when I export a report like "Active computers" to XLSX, column Last-Logon-Timestamp will only be recogniced in Excel as text format. Is this a normal behaviour or perhaps a language problem between Windows and Office? We have English Windows installation with German Input language, Format and Location.

regards Helmut

by (510 points)

1 Answer

0 votes
by (305k points)

Hello,

Yes, this is a normal behavior. All cells in exported reports have the General format.

Related questions

0 votes
1 answer
Export Users to CSV AccountExpires date problem

I tried the script located here: http://www.adaxes.com/script-repository ... s-s346.htm The script works well for most fields (including adm-custom fields), but when ... a value something like "129915720000000000" instead of a date. Any way to resolve this?

asked Feb 15, 2017 by Kikaida (1.1k points)
0 votes
1 answer
How to create report which shows the last logon date of every disabled user in the last 30 days?

The report criteria would be as follows, Name/Last Logon Date of any user that was disabled in the last 30 days. Furthermore, if possible, how would I publish this to the user ... run a report and/or choose which dates to run the report, on his own? TIA

asked Nov 26, 2024 by Milan.Pathak (40 points)
0 votes
1 answer
Export Report Filtered Results

How can we export a report with a filter applied? When running a report, and applying a filter and clicking export to say Excel, all results from the report ... instead prints only the filtered results, we would like to export filtered results. Thanks!

asked Aug 18, 2023 by curtisa (350 points)
0 votes
1 answer
Report CSV export

I have a report that I am exporting to a directory but the output has two issues which are not usable for an import at another system after an automated FTP. ... the automated process cannot have any extraneous columns and the Name column would be one.

asked Mar 16, 2023 by techg (320 points)
0 votes
0 answers
Adaxes web report not sorting last logon date but console report is sorting fine

I have a report which is basically a query for specific set of users for which I want the last logon attribute (not the last logon timestamp). When I sort the same report ... fine. But the same report in Adaxes web portal the sort is not working the same way.

asked May 23, 2024 by Vish539 (500 points)
3,742 questions
3,420 answers
8,641 comments
1,388 users