[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[],[],null,["WEEKDAY\n=======\n\nReturns a number representing the day of the week for a given date.\n\nSample usage\n------------\n\n`WEEKDAY(Date)`\n\nSyntax\n------\n\nThe following syntax returns a number that represents the day of the week from a Date value.\n\n`WEEKDAY( `\u003cvar translate=\"no\"\u003edate_expression\u003c/var\u003e` )`\n\nThe following syntax returns a number that represents the day of the week from a compatibility mode Date value.\n\n`WEEKDAY( `\u003cvar translate=\"no\"\u003eX\u003c/var\u003e` [, `\u003cvar translate=\"no\"\u003eformat_string\u003c/var\u003e` ])`\n\n### Parameters\n\n- \u003cvar translate=\"no\"\u003edate_expression\u003c/var\u003e - a Date \\& Time field or expression.\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e - a field or expression that evaluates to Text, Number, or compatibility mode Date.\n- \u003cvar translate=\"no\"\u003eformat_string\u003c/var\u003e - format for \u003cvar translate=\"no\"\u003eX\u003c/var\u003e. Optional if \u003cvar translate=\"no\"\u003eX\u003c/var\u003e is correctly configured as a semantic date field.\n\n#### Input format for compatibility mode dates\n\nSupported date functions accept the following input formats if `X` is a Text field or expression, or compatibility mode Date:\n\n- `BASIC`: %Y/%m/%d-%H:%M:%S\n- `DEFAULT_DASH`: %Y-%m-%d \\[%H:%M:%S\\]\n- `DEFAULT_SLASH`: %Y/%m/%d \\[%H:%M:%S\\]\n- `DEFAULT_DECIMAL`: %Y%m%d \\[%H:%M:%S\\]\n- `RFC_1123`: for example, Sat, 24 May 2008 20:09:47 GMT\n- `RFC_3339`: for example, 2008-05-24T20:09:47Z\n- `DECIMAL_DATE`: same as `DEFAULT_DECIMAL`\n\nAny valid [strptime](http://pubs.opengroup.org/onlinepubs/009695399/functions/strptime.html) format is accepted.\n\nSupported time functions accept the following input format if `X` is a Number field or expression:\n\n- `SECONDS`: seconds since Epoch\n- `MILLIS`: milliseconds since Epoch\n- `MICROS`: microseconds since Epoch\n- `NANOS`: nanoseconds since Epoch\n- `JULIAN_DATE`: days since Epoch\n\nExamples\n--------\n\nNotes\n-----\n\nThis function works with both compatibility mode dates and [upgraded Date and Date \\& Time](/looker/docs/studio/dates-and-times) data types.\n\nDays are counted from Sunday and the value of Sunday is 0, therefore the value of Saturday is 6.\n\nRelated resources\n-----------------\n\n- [Dates and times](/looker/docs/studio/dates-and-times)\n- [About calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Looker Studio function list](/looker/docs/studio/function-list)"]]