Views:

Product: LABELVIEW, CODESOFT

Version: All Versions

 

WeekISO8601(«Date», «DateFormat»): Allows you to create a formula that support the ISO8601. ISO 8601 is an international standard covering the exchange of date and time-related data.

Return value

date

Returns the week of the specified date

Date

string

A text format date, to be converted to a date value.

DateFormat

string

Format of the base date value.

- Numbers encode predefined formats.
(e.g. 1 dd/mm/yy, 2 dd/mm/yyyy and so on

- 0 or negative values means using the current system date format

- String value encode the format directly. (e.g. "yyyy/mm/dd")

Example:
WeekISO8601(" 03/01/2010 ",0) = 53
WeekISO8601(" 02/01/2011 "," dd/mm/yyyy ") = 52
WeekISO8601(" 01/01/2011 ", " dd/mm/yyyy ") = 52

 
Keywords: weekiso8601, weekiso8601 formula, weekiso8601 function, international exchange of standard date and time, LABELVIEW formula, CODESOFT formula