ExcelBanter - date format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - date format (https://www.excelbanter.com/excel-programming/421747-date-format.html)

bijan

date format

Hi all
when I get data from database(SQL queries) it shows date format like 38306
instead of 2004/11/15, how can I converted this date format automatically
during executing queries?
Thanks

mikeaj72[_9_]

date format

Maybe like this
Columns("A:A").NumberFormat = "yyyy/mm/dd"

--
mikeaj72
------------------------------------------------------------------------
mikeaj72's Profile: http://www.thecodecage.com/forumz/member.php?userid=46
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44465

Per Jessen[_2_]

date format

Hi

Format the column as Date, then all dates should appear correct.

Regards,
Per

On 27 Dec., 15:43, bijan wrote:
Hi all
when I get data from database(SQL queries) it shows date format like 38306
instead of 2004/11/15, how can I converted this date format automatically
during executing queries?
Thanks

All times are GMT +1. The time now is 02:59 AM.