Converting MM/DD Date Format to DD/MM in Excel with Report Generation Toolkit
Primary Software: LabVIEW Toolkits>>LabVIEW Report Generation Toolkit for Microsoft Office
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A
How can I programmatically convert MM/DD/YYYY (12/31/2008) date format into DD/MM/YYYY (31/12/2008) date format using National Instruments Report Generation Toolkit for Microsoft Office?
Microsoft Excel handles date and time as a floating point decimal representation. The integral value (to the left of the decimal) represents the number of days since the beginning of the 20th century. The decimal value represents the time of day from midnight in seconds divided by 86,400 (i.e. 6:00:00PM = 0.75).
Excel chooses the default regional date format (i.e. MM/DD/YYYY, DD/MM/YYYY, etc.) based on your current location setting. In Excel, you can manually change the format of a particular cell by right clicking on any cell and selecting Format Cells, then selecting Date, and finally changing the Locale (location) to the desired format. This allows you to format the date however you'd like.
Unfortunately, Excel does not have a function call to programmatically change the Locale (location) setting for a cell, but there are a couple of work-arounds to write dates to Excel in the format DD/MM/YYYY.
KnowledgeBase 3EJEC9NS: Report Generation Toolkit Compatibility with Microsoft Office and LabVIEW
Report Date: 05/10/2004
Last Updated: 07/28/2014
Document ID: 399K1MNH