ENDOFPERIOD

This function extracts a certain date from a given date.

Parameters:

  • Expression. Type: Date.
  • Period type. A string containing one of the following values:
  • Minute
  • Hour
  • Day
  • Week
  • Month
  • Quarter
  • Year
  • TenDays
  • HalfYear

ENDOFPERIOD(DATETIME(2009, 10, 12, 10, 15, 34), "Week")

Result:

 10/13/2009 11:59:59 PM

Next page: DATEADD

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.