If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date parameters
I want to be able to enter a date and have it pull everthing 30 days in the
future... it is for expiry date warnings |
#2
|
|||
|
|||
Date parameters
You could use criteria like
Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date]) John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Norm wrote: I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings |
#3
|
|||
|
|||
Date parameters
Thanks John
I tried this and when I enter the start date the too complex box pops up Is there something I missed or forgot to do, I entered the statement below in the criteria box Cheers!!! "John Spencer" wrote: You could use criteria like Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date]) John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Norm wrote: I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings . |
#4
|
|||
|
|||
Date parameters
Are you setting this criteria against a true date field? If so, you may need
to add the data type in the Query-Parameters: [Enter Start Date] Date/Time -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Norm" wrote: Thanks John I tried this and when I enter the start date the too complex box pops up Is there something I missed or forgot to do, I entered the statement below in the criteria box Cheers!!! "John Spencer" wrote: You could use criteria like Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date]) John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Norm wrote: I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings . |
#5
|
|||
|
|||
Date parameters
I cannot change data type as this is a linked table
Is there any other way? "Duane Hookom" wrote: Are you setting this criteria against a true date field? If so, you may need to add the data type in the Query-Parameters: [Enter Start Date] Date/Time -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Norm" wrote: Thanks John I tried this and when I enter the start date the too complex box pops up Is there something I missed or forgot to do, I entered the statement below in the criteria box Cheers!!! "John Spencer" wrote: You could use criteria like Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date]) John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Norm wrote: I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings . |
#6
|
|||
|
|||
Date parameters
Can you provide the SQL view?
Can you provide the actual data type? Can you provide some sample values in the field? Have you checked any help on how to convert a field to a date value? -- Duane Hookom MS Access MVP "Norm" wrote in message ... I cannot change data type as this is a linked table Is there any other way? "Duane Hookom" wrote: Are you setting this criteria against a true date field? If so, you may need to add the data type in the Query-Parameters: [Enter Start Date] Date/Time -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Norm" wrote: Thanks John I tried this and when I enter the start date the too complex box pops up Is there something I missed or forgot to do, I entered the statement below in the criteria box Cheers!!! "John Spencer" wrote: You could use criteria like Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date]) John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Norm wrote: I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings . |
#7
|
|||
|
|||
Date parameters
"Norm" schrieb im Newsbeitrag ... I want to be able to enter a date and have it pull everthing 30 days in the future... it is for expiry date warnings |
Thread Tools | |
Display Modes | |
|
|