GetEuroSummerTime ( numYear ; txtParameter )

Calculates the start or end date of the European Summer Time

Average rating: 4.6 (31 votes) Log in to vote

Mark de Haas Meijer
Emlogic
http://www.emlogic.nl

Sample input:

GetEuroSummerTime (2010 ; "Start")

GetEuroSummerTime (2010 ; "End")

Sample output:

28-3-2010

31-10-2010

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

If(IsEmpty(numYear) = 0 and (txtParameter = "Start" or txtParameter = "End");
Let(intMonth = If(txtParameter = "Start" ; 3 ; 10);
Date(intMonth ; 31 - DayOfWeek(Date(intMonth ; 31 ; numYear)) + 1 ; numYear)))

Calculates the start or end date of the European Summer Time (European Daylight Saving Time).

Comments

		Marc Zoutendijk, Vught Mar 29, 2010
The official name for 'summertime' is Daylight Savings Time. Summertime is a famous song by Gershwin!

		Mark de Haas Meijer, Almere Mar 30, 2010
Marc, thanks for your comment. I'll change the function name into GetDST.

		comment, VR Mar 31, 2010
Actually, the official name is "summer-time period" -see: http://en.wikipedia.org/wiki/European_Summer_Time

		Mark de Haas Meijer, Almere Mar 31, 2010
I'm convinced that GetEuroSummerTime is the best name for this function.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetEuroSummerTime ( numYear ; txtParameter )

Comments

Support this website.

Support this website.