Skip to main content
AkmarulSalleh5-Regular Member
5-Regular Member
Jan 4, 2025 8:09 AM UTC
Solved

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

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.

AkmarulSalleh_0-1735977820463.png

 

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

AkmarulSalleh_1-1735977914663.png

 

Regards

 

 

LucMeekesAnswer
23-Emerald V
Jan 7, 2025 7:19 AM UTC

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

View in thread

14 replies

LucMeekes23-Emerald V
23-Emerald V
Jan 4, 2025 9:13 AM UTC

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

 

Success!

Luc

Translate
AkmarulSalleh5-Regular MemberAuthor
5-Regular Member
Jan 4, 2025 9:23 AM UTC

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

Translate
AkmarulSalleh5-Regular MemberAuthor
5-Regular Member
Jan 4, 2025 9:29 AM UTC

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

AkmarulSalleh_0-1735982912966.png

 

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jan 4, 2025 11:38 AM UTC

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?

Translate
AkmarulSalleh5-Regular MemberAuthor
5-Regular Member
Jan 5, 2025 9:52 AM UTC

AkmarulSalleh_0-1736070728528.png

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

 

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jan 5, 2025 8:33 PM UTC

Might be an Excel problem

See Excel 2013 Incorrect Date Created | Microsoft Learn

Translate
Terms & ConditionsAccessibility statement