Brian Dunning's FileMaker Custom Functions

DayLightSavings ( TargetDate ; TargetTime ; Hours )

Day Light Saving Time

  Average rating: 4.0 (41 votes) Log in to vote

Tim Brown   Tim Brown
Antidote Solutions
http://www.antidotesolutions.com

Share on Facebook Share on Twitter

  Sample input:
DayLightSavings ( 11/2/2008 ; 7:00 AM ; -24 )
  Sample output:
11/1/2008 6:00 AM

should daylight savings occur during the -24 hour period, it will adj the output time by an hour.

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

This is used in a medical situation where the number of hours between an event and a procedure is critical.



Take in consideration Day Light Savings Time if you need to calculate the correct time. This calculation only considers an overlap of 1 day light savings time.

You can enter hours as negative or positive

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.