BookmarkSubscribe
Choose Language Hide Translation Bar
m4mazzotti
Community Trekker

Date losing formatting during save

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.

 

  1. Load an Excel file with the date on the format d/m/y (02/05/2018)
  2. Save that same table as an excel
  3. 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" ));
0 Kudos
1 REPLY 1
Highlighted

Re: Date losing formatting during save

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