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
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar