Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 16, 06:29 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 177
Default data connection table date help

I have data connection pulling a SQL query, I am using:

CONVERT(VARCHAR(10), TASK_DATE_CREATED, 101) AS [Task Orig Date]

to create the Task Orig Date field. However, this is not putting it into my data table as a 'date' automatically and is imported as text initially (I have to 'activate' the cell, then leave the cell to have it count as a 'date').
I can write VBA to go through the entire range cell by cell and do this, but does anyone know a systemic way to have the data import as a date to begin with? is there other info you need to know to help? Gracias amigos!

  #2   Report Post  
Old December 8th 16, 08:57 AM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2016
Posts: 4
Default

Thanks bác, giờ mình mới biết đến thông tin hữu *ch n*y. Ai có những thông tin dạng như thế n*y post lên cho mọi người cùng tham khảo luôn nhé. Đang rất quan tâm
  #3   Report Post  
Old December 8th 16, 09:32 AM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 2
Default

Thanks bác, giờ mình mới biết đến thông tin hữu *ch n*y. Ai có những thông tin dạng như thế n*y post lên cho mọi người cùng tham khảo luôn nhé. Đang rất quan tâm


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table with Data Model Connection - getpivotdata #REF error Nirmalya Choudhury Excel Discussion (Misc queries) 0 March 28th 14 07:03 PM
Pivot Table with Data Model Connection - getpivotdata reference issue Nirmalya Choudhury Excel Worksheet Functions 0 March 28th 14 06:50 PM
Excel 2007: Data connection returned empty table Abel MacAdam Excel Programming 0 July 30th 09 02:01 PM
Pivot Table loses Data Connection Dead.Zone Excel Discussion (Misc queries) 0 July 7th 09 02:45 PM
Pivot Table Data Connection J.Rogers Excel Programming 0 June 28th 06 08:56 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017