Re: Criteria for date

On Tue, 26 Jul 2005 19:07:53 -0600, John Vinson
<jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>On Wed, 27 Jul 2005 10:26:50 +1000, Robin Chapple
><robinski@xxxxxxxxxxxxx> wrote:
>
>>IIf(Date()>DateSerial(Year(Date()),7,45),DateAdd("d",-45,Date()),DateSerial(Year(Date()),7,1))
>>And <=Date()
>>
>>I must be close.(I hope)
>
>Try putting the various expressions into vacant Field cells just to
>see what date is being returned:
>
>DateSerial(Year(Date()),7,45)
>DateAdd("d",-45,Date())
>IIf(Date()>DateSerial(Year(Date()),7,45),DateAdd("d",-45,Date()),DateSerial(Year(Date()),7,1))
>
>If you manually enter these dates into the >= and <= criteria what do
>you get?
>
i) 13/06/2005

ii) 14/08/2005

iii) 1/07/2005

The manual advice I don't understand.

Robin Chapple

My guess is >=13/06/2005 and <=14/08/2005

which I did not try because it is not what is intended.

Thanks,

Robin



> John W. Vinson[MVP]

.

Loading