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.

Thanks again John,

That is just what the doctor ordered. I still have my version 2
manuals and I have found the function and will add it to my list to study.

Regards,

Robin Chapple

At 27/07/2011 05:53 PM, you wrote:
>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
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>