Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Woodkat
 
Posts: n/a
Default Using imported Query & Calculating Dates

When importing a query dates are entered in excell as text (YYYYMMDD). Is
there a way to control how the query imports the data? If not, I am having
difficulty creating a formula that would tell me which birthdays occur 2-3
weeks from today.

My old formula worked using the text import and converting the text column
to the correct date format:
=IF(AND(DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))=TOD AY()+7,DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))<=TODA Y()+14),"Send Card!","")). Any one have an idea?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you could use 'Data - Text to columns' afterwards to convert these
values to a real date value

--
Regards
Frank Kabel
Frankfurt, Germany

"Woodkat" schrieb im Newsbeitrag
...
When importing a query dates are entered in excell as text

(YYYYMMDD). Is
there a way to control how the query imports the data? If not, I am

having
difficulty creating a formula that would tell me which birthdays

occur 2-3
weeks from today.

My old formula worked using the text import and converting the text

column
to the correct date format:

=IF(AND(DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))=TOD AY()+7,DATE(YEAR(TODA
Y()),MONTH(P2),DAY(P2))<=TODAY()+14),"Send Card!","")). Any one have
an idea?

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
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 08:43 PM
Microsoft Query Help Patti Excel Worksheet Functions 4 December 25th 04 10:54 AM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 08:54 PM
Editing MS Query Patti Excel Worksheet Functions 2 December 2nd 04 02:31 PM


All times are GMT +1. The time now is 07:46 PM.

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

About Us

"It's about Microsoft Excel"