| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I query a future date?
In Excel 2003, I calculate a future date for prescription refill dates based
on one day less than NbrWeeksTillRefill weeks using the following expression. RefillDateCalc: DateSerial(Year([tbl Prescriptions]![BeginDate]),Month([tbl Prescriptions]![BeginDate]),Day([tbl Prescriptions]![BeginDate])+[tbl Prescriptions]![NbrWeeksTillRefill]*7-1) That works fine, but when I try to query it I get a data type mismatch error with a date, text or number. Excel seems to recognize it as a date and will format it as a date any way I wish. I created another field equal to this field, and can query it using the expression Between [Beginnng Date] and [Ending Date], but it asks for the parameter value of RefillDateCalc and returns no results. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE QUERY DATA TO A DATE RANGE? | Excel Worksheet Functions | |||
| How do I calculate a future date in excel? | Excel Worksheet Functions | |||
| How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Linear Mode
