Using imported Query & Calculating Dates

[Woodkat]

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))>=TODAY()+7,DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))<=TODAY()+14),"Send Card!","")). Any one have an idea?

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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))>=TODAY()+7,DATE(YEAR(TODA
Y()),MONTH(P2),DAY(P2))<=TODAY()+14),"Send Card!","")). Any one have
an idea?