EndOfWeek

returns the utc date and time for the end of the local week based on the local date and time of the current session in , the beginning of the week is sunday syntax endofweek(numweeks, basedatetime, timezone) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes business rules editing rules yes business rules initialization rules yes business rules read only rules yes business rules required rules yes business rules validation rules yes client expressions yes object permissions yes services yes ldap yes mobile yes quick actions (except ui quick actions) yes ui quick actions yes reports yes search/dashboard without field references yes search/dashboard with field references yes parameters parameter description numweeks (optional) the number of intervals if not specified, uses the default interval which is 0 can be either a positive integer, to indicate weeks in the future, or a negative integer, to indicate weeks in the past basedatetime (optional) the base date for the function if not specified, uses the default date which is the current date and time timezone (optional) the time zone, in iana format return value datetime value in utc time if the application has to display the return value, it implicitly converts it to text, thereby allowing the display format to change depending on your culture code see available languages and cultures docid\ lvpbgqv5z08mcuzy43ky3 for a list of the culture codes used by in this release of , there is a known issue, where if the time zone offset between the current date and time and the datetime value returned by the function is different, the return value is off by one hour this happens when the current date is before daylight savings time and the datetime value that is returned is after daylight savings time, or vice versa example $(endofweek()) if the current date is wednesday january 15, 2014 and your time zone is pacific time (which is utc 7 during daylight savings time but utc 8 during standard time), this function returns the very last tick of the week, which is saturday january 18, 2014 at 11 59 59 9999 pm converted to utc time, which is sunday january 19, 2014 at 07 59 59 9999 am