Using imported Query & Calculating Dates

W

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?
 
F

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

Woodkat said:
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:
Click to expand...
=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?
 
Top