Date Time format from System

[snagytx]

Hello,

Is it possible to add date/time fields with the format getting pulled from the system? I don't want to set the format manually, I just want to mark the field as date/time field.

The date/time fields should be updated automatically when opened in different system date/format settings. Us us MM/DD/YYYY while EU is DD/MM/YYYY.

Thanks.

[jmcnamara]

The date/time fields should be updated automatically when opened in different system date/format settings. Us us MM/DD/YYYY while EU is DD/MM/YYYY.

Excel has some built in formats that change with the system:

You can enable these with libxlsxwriter using the format_set_num_format_index() function:

      format = workbook_add_format(workbook);
      format_set_num_format_index(format, 14); // m/d/yy

[snagytx]

Yes, I was about to test using format_set_num_format_index