# Export to Excel 2010 -- Dates

**URL:** <https://forums.toadworld.com/t/export-to-excel-2010-dates/7080>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 6, 2012, 11:56am UTC](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080 "2012-02-06T11:56:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdamS](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@AdamS](https://forums.toadworld.com/u/AdamS)\
**Post date:** [February 6, 2012, 11:56am UTC](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080/1 "2012-02-06T11:56:15Z")

</div>

When I attempt to export results to Excel 2010 from a query against Teradata using ODBC connection the date columns appear blank in Excel. Any suggestions?

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [February 6, 2012, 3:06pm UTC](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080/2 "2012-02-06T15:06:05Z")

</div>

I unsuccessfully tried to reproduce the issue using mytest environment and Excel 2007.

What is local setting on your PC?

What is the formatof the date column?

You can see it by executing Help command

Help Column YOUR\_DATE\_COLUMN\_NAME From YOUR\_DATABASE\_NAME .YOUR\_TABLE\_NAME;

Could you please run the following test case

1. Create table

create table Test\_Date

(id integer primary key not null,

date\_column date);

– let’s insert some data

insert into Test\_Date values (1, ‘2012-02-06’);

insert into Test\_Date values (2, ‘2012-02-07’);

– check the data

select \* from Aleksey.Test\_Date;

Could you please provide a screenshot of what do you get fromthe Select statement?

Could you export it to Excel?

Now you can drop the table using

Drop Table Test\_Date ;

---

<div class="post-metadata">

**Author:** ![andrew.login](https://avatars.discourse-cdn.com/v4/letter/a/f9ae1b/32.png) [@andrew.login](https://forums.toadworld.com/u/andrew.login)\
**Post date:** [July 4, 2014, 2:46am UTC](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080/3 "2014-07-04T02:46:51Z")

</div>

I had the same problem when converting julian to gregorian dates in my SQL statement.

I found if Exported to CSV that the dates were included in the output, so it’s not a problem with Toad - I therefor assumed it was something to do with Excel not accepting or being able to cope with the data and data type combination being sent to it by Toad.

In the end I cheated by casting my SQLdate conversion statement into varchar and the date appeared in Excel 2010 … I have not tried to figure out what that means in terms of data types, but it worked for me.

Of course if you want to use actual dates in Excel calculations, then this won’t work for you.