topic Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp in Mathcad

Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh — Sat, 04 Jan 2025 08:09:33 GMT

Hello all,

I found out the WRITEEXCEL generate excel file with wrong time stamp. This is my worksheet.

test1.xlsx is a simple file, that contain 4x3 information.

Timestamp generated is 28 March 2009. Anyone facing the same issue?

Regards

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

LucMeekes — Sat, 04 Jan 2025 09:14:34 GMT

Depends on what timestamp you're looking at. Is it the creation date, or the latest access date?

Success!

Luc

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh — Sat, 04 Jan 2025 09:23:48 GMT

Hello. It is the creation time. I just created test5.xlsx today, but the date for the file is 28 March 2009.

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh — Sat, 04 Jan 2025 09:29:06 GMT

You can try this simple 1 line code, and verify if the date is correct. I still got 28 March 2009.. hmm... weird..

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

Werner_E — Sat, 04 Jan 2025 11:38:23 GMT

I can't duplicate the issue.

When I create an Excel file via WRITEEXCEl, it gets the correct system date.

You are sure that OS date/time are set correct on your system?

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh — Sun, 05 Jan 2025 09:52:59 GMT

System Date is all correct. I never have this kind of issue, with other software. I'll ask Mathcad Technical support

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

LucMeekes — Sun, 05 Jan 2025 10:28:54 GMT

Ok. Checked with Prime 10.0.0.0 Express.. Cannot confirm exactly, 'cause for me the date is one day earlier:

The same occurs with Prime2 and 4 express (exact same date and time) so is probably true for all versions of Prime. Note that the date predates Prime1. Probably a design-time constant was used for setting the date. The bug does not occur in (real) Mathcad because the function doesn't exist there.

I propose you report it to PTC.

Success!

Luc

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

Werner_E — Sun, 05 Jan 2025 20:17:04 GMT

Strange!

I tested with the full versions of Prime 10.0.1.0 and Prime 9 as well as with the Express version of Prime 6 and the command

resulted in a newly created Excel file with the correct system date as date of creation, date of last change and date of last access.

Using Win 10 pro and Excel 2016.

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

Werner_E — Sun, 05 Jan 2025 20:33:25 GMT

Might be an Excel problem

See Excel 2013 Incorrect Date Created | Microsoft Learn

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

LucMeekes — Sun, 05 Jan 2025 23:17:49 GMT

I didn't use Excel (at least not explicitly), just created the file from within Prime and checked the date in Windows's file explorer....

And, there's no Excel 2013 installed on my PC...

Luc.

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

LucMeekes — Mon, 06 Jan 2025 22:58:41 GMT

Tried on another machine.

Writing to "file.xlsx" produced an 8 kB file (new office format: zipped archive of xml files) with the old date.

Writing to "file.xls" produced a 1kB file (old format: binary etc) with the current date and time.

This may be a work-around.

Success!
L:uc

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh — Tue, 07 Jan 2025 01:48:04 GMT

MP10.0.1.0

I have tried, but would not work.

Regards,

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

terryhendicott — Tue, 07 Jan 2025 02:48:59 GMT

Hi Ak

use the extension *.xlsx" as the error message says:

I get the current system date for the excel files.

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

LucMeekes — Tue, 07 Jan 2025 07:19:12 GMT

Ah, apparently they've dropped that possibility somewhere between Prime 4 (where it is possible) and Prime 9 (get the same error message as you).

Success!
Luc

Re: Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

Werner_E — Tue, 07 Jan 2025 11:17:00 GMT

I just tested and Prime 6 still is able to create xls files, Prime 9 can't. Can't say about versions 7 and 8 (never installed them).

But as already said all files created, whether xls or xlsx and regardless with which version of Prime get the correct system date.

So it seems not to be a Prime only problem but must have to do with something else as well. It also seems to work OK for Terry as well.