what is the result of the following formula datevalue date startof date add date2017 11 15yyyy mm dd year 1 quarter yyyymmdd 12597

What is the result of the following formula? DATEVALUE( DATE_STARTOF( DATE_ADD( DATE(“2017-11-15″,”yyyy-MM-dd”), year, “-1”), quarter), “yyyyMMdd”)

by

Advertisement

  • 20161115
  • 2017-10-01
  • 2017-01-01
  • 20161001
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

We respect your privacy and take protecting it seriously

Leave a Comment

Share via
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

We respect your privacy and take protecting it seriously

Send this to a friend