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?

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?