| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| Query of External Data | Excel Discussion (Misc queries) | |||
| Microsoft Query Help | Excel Worksheet Functions | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Editing MS Query | Excel Worksheet Functions | |||
Threaded Mode
