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 (289k 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
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 by Vish539 (460 points)
0 votes
2 answers
Report-Specific Column Extracting Date From String

I am trying to create a report-specific column (DateTime - Regular Date) where I can extract the datetime from the description field of the user object using a regular ... () $line = $object.Get("description") $dateTime = ?? $Context.Value = $dateTime

asked Feb 27 by emeisner (100 points)
+2 votes
1 answer
Account approval date in report

I am attempting to build out a report that shows all user accounts were approved by two different persons before being created. I have the workflow running correctly, ... this data stored in a specific location thats accessible by the reporting engine? Thanks!

asked Dec 16, 2019 by hendersonw (210 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 (290 points)
3,548 questions
3,239 answers
8,232 comments
547,814 users