How to display year season from date entry

[Allaw212]

Hello

I am quite stuck with creating a solution to display a season name (i.e summer, winter, etc) from when a user enters a Date



How can i assign multiple values onto my "date" data type, and how can i eliminate specifying a year or perhaps set the year value to infinity??

would i have to use If-Else statements, if so then how??

please help

[pbaldy]

I would probably create a table with two fields, one for the month (1) and the other for the related season (winter). You could then get the related season in a number of ways (query join, DLookup, etc).

[ConneXionLost]

Note that along with Paul's suggestion, you can/should use the "Month" function to find a month number from any given date. For example:

MonthNo: Month([GivenDate])

This will allow you to ignore the year and limit your lookup table "tlkpSeason" to only 12 records.

Cheers,

[TheShabz]

It depends on how accurate you want to be. If I'm not mistaken, season changes occur on the 21st of the month. Technically, the entire month might not be part of 1 season. I think you'll want to format the date to remove the year (google the format function) and then run multiple if-else or switch statements to provide your seasons.

ex. (psudo-code)

If myDate Between beginDate And endDate Then
season = "winter"

etc...