getting season from date

R

Roma

Hi everyone,
How can I automatically get the name of the season when
the user inputs the date?
Thanks.
 
D

Dirk Goldgar

Roma said:
Hi everyone,
How can I automatically get the name of the season when
the user inputs the date?
Thanks.
Click to expand...

I suppose it would depend on how you define your seasons. If you simply
go by months, you could use something like this:

=Choose(Month([DateGiven]),"Winter", "Winter", "Spring", "Spring",
"Spring", "Summer", "Summer", "Summer", "Autumn", "Autumn", "Autumn",
"Winter")

Note: the above was entered all on one line, though it will have been
wrapped by the newsreader.
 
M

Mike Painter

Neat.

In California it might be
=Choose(Month([DateGiven]),"Winter", "Winter?", "Spring", "Summer",
"Summer", "SUMMER", "SUMMER", "*SUMMER*", "Summer", "Autumn", "Autumn",
"Winter?")




Dirk Goldgar said:
Roma said:
Hi everyone,
How can I automatically get the name of the season when
the user inputs the date?
Thanks.
Click to expand...

I suppose it would depend on how you define your seasons. If you simply
go by months, you could use something like this:

=Choose(Month([DateGiven]),"Winter", "Winter", "Spring", "Spring",
"Spring", "Summer", "Summer", "Summer", "Autumn", "Autumn", "Autumn",
"Winter")

Note: the above was entered all on one line, though it will have been
wrapped by the newsreader.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
D

Dirk Goldgar

Mike Painter said:
Neat.

In California it might be
=Choose(Month([DateGiven]),"Winter", "Winter?", "Spring", "Summer",
"Summer", "SUMMER", "SUMMER", "*SUMMER*", "Summer", "Autumn",
"Autumn", "Winter?")
Click to expand...

LOL
 
Top