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

[AkmarulSalleh]

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

[LucMeekes]

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

Success!

Luc

[AkmarulSalleh]

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

[AkmarulSalleh]

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

[LucMeekes]

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

[Werner_E]

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.

[Werner_E]

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?

[AkmarulSalleh]

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

[Werner_E]

Might be an Excel problem

See Excel 2013 Incorrect Date Created | Microsoft Learn

[LucMeekes]

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.

[LucMeekes]

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

[AkmarulSalleh]

MP10.0.1.0

I have tried, but would not work. 

Regards,

Ak

[terryhendicott]

Hi Ak

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

I get the current system date for the excel files.

[LucMeekes]

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

[Werner_E]

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.