Hello There,
Date formatting gets messe-up when saving via script. Ive tryied saving the table via the table window and it worked... I cant figured out what is wrong.
- Load an Excel file with the date on the format d/m/y (02/05/2018)
- Save that same table as an excel
- Open the Excel and the date is now 05/02/2018
LoadDB = Expr(
dt = Open(
"$DESKTOP\SCENARIO DETAILS.xlsx",
Visible,
Worksheets( 1 ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
Data Starts on Row( 2 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 1 ),
Replicated Spanned Headers( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 0 ),
Treat as Hierarchy( 0 ),
Multiple Series Stack( 0 ),
Import Cell Colors( 0 ),
Limit Column Detect( 0 ),
Column Separator String( "-" )
)
);
Column( dt, "PROGRAM END DATE" ) << Data Type( Numeric ) << Set Modeling Type( Continuous ) << Format( "d/m/y", 12 );
);
LoadDB;
Close( dt, Save( "$DESKTOP\SCENARIO DETAILS.xlsx" ));
Good Morning,
I am with JMP Technical Support. I have been able to replicate the issue you describe. I will create a feature enhancement request for this issue and submit it to development for review.
Should you request additional assistance on this specific issue, please create a JMP Technical Support track (email: support@jmp.com) and reference this post. Feel free to direct the email to me.
Best regards,
Bobby Riggs
