Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109736 > unrolled thread

data connection table date help

Started byMatthew Dyer <matthew.e.dyer@gmail.com>
First post2016-12-07 10:29 -0800
Last post2016-12-08 09:32 +0000
Articles 3 — 3 participants

Back to article view | Back to microsoft.public.excel.programming

Contents

  data connection table date help Matthew Dyer <matthew.e.dyer@gmail.com> - 2016-12-07 10:29 -0800
    Re: data connection table date help Amandabui252 <Amandabui252@gmail.com> - 2016-12-08 08:57 +0000
    Re: data connection table date help Sandytran144 <Sandytran144@gmail.com> - 2016-12-08 09:32 +0000

#109736 — data connection table date help

FromMatthew Dyer <matthew.e.dyer@gmail.com>
Date2016-12-07 10:29 -0800
Subjectdata connection table date help
Message-ID<68f95d63-7f8f-4229-8b6a-01b3144667e9@googlegroups.com>
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!

[toc] | [next] | [standalone]

#109737

FromAmandabui252 <Amandabui252@gmail.com>
Date2016-12-08 08:57 +0000
Message-ID<Amandabui252.128ee208@excelbanter.com>
In reply to#109736
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




-- 
Amandabui252

[toc] | [prev] | [next] | [standalone]

#109738

FromSandytran144 <Sandytran144@gmail.com>
Date2016-12-08 09:32 +0000
Message-ID<Sandytran144.128ee208@excelbanter.com>
In reply to#109736
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




-- 
Sandytran144

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web