ACCESS FEED: RE: [MS_AccessPros] Code does not find dates as expected.

Rabu, 27 Juli 2011

RE: [MS_AccessPros] Code does not find dates as expected.

Robin-

WHERE RecordDate BETWEEN DateSerial(Year(Date()), 7, 1) And
DateSerial(Year(Date())+1, 6, 30)

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Wednesday, July 27, 2011 9:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Code does not find dates as expected.

My organisation has a year which starts on July 1st. I have been
using this code:

IIf(Month(Date())>=7,DateSerial(Year(Date()),7,1),DateSerial(Year(Date())-1,7,1)
)

to decide if an entry is "This Organisational Year". The original
need was to identify post holders in the year, and appointments are
from 1st July.

I have recently applied it to a table where the day part of the date
is variable and when the date is not 1st and the month is not July
and records are missed.

How do I edit the code to include any date between 1st July, this
year up to 31st December and from 1st January to 30th June in the next year?

I have no idea!

Many thanks,

Robin Chapple

------------------------------------

Yahoo! Groups Links