Hi,
I have a format that I need to keep when the data is String (due to the first lines).
I am extracting this data to excel and I need the dates to be in Date format and not string.
Is there a way to do that?
Thanks,
Sahar
Solved! Go to Solution.
Hi @sahartz
Here is a way how you can do it. The trick is to output the headers anything above col name separately(in your case Original Due Date) and table with headers separately (Col name and data)
1. Make sure the line above header is executed first and in output tool you have checked skip field names
2. Now for writing the actual data table you need to mention range from A2:ZZ99999 (2nd row to estimated max range) while setting the sheet name. Once you have set it will reflect in the path. This the table is written from row 2 and data type wont be affected.
3. Make sure both write options are set to overwrite sheet.
Output:
Hope this helps 🙂
Hi @atcodedog05
Thanks!!!! I managed to include all the data in the excel.
1 last question, do you know how can I change the date so the year will be 4 digits and not only 2 ?
Hi @sahartz
Just a rough guess can you change zz to ZZ in the sheetname range in the below configuration.
I guess you figured it out @sahartz 🙂
Hi @sahartz
That is purely your excel format. What you can do is you set the date formatting in the excels column cells in advance. And use output tool with preserve output formatting like below. This way it takes the existing formatting.
Hope this helps 🙂