getting season from date

[Roma]

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

 

[Dirk Goldgar]

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

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.

 

[Mike Painter]

Neat.

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

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

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)

 

[Dirk Goldgar]

Neat.

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

LOL