day function in the Factory
The day function returns the day value of the date.
Parameters Parameter Description date The date, week, month, quarter, datetime attribute we want to use to cast the day. The date parameter is mandatory. Date type valid formats (if the values aren’t this format, the function will return an error). 2019/10/12; 12/10/2019; 2019-10-12; 12-10-2019; 2019/Oct/12; 12/Oct/2019; 2019-Oct-12; 12-Oct-2019. Week type valid formats (if the values aren’t this format, the function will return an error). 2019/W41; W41/2019; 2019-W41; W41-2019. Month type valid formats (if the values aren’t this format, the function will return an error). 1492/10; 10/1492; 1492-10; 10-1492; 1492/Oct; 1492-Oct; Oct/1492; Oct-1492. Quarter type valid formats (if the values aren’t this format, the function will return an error). 2019/Q3; Q3/2019; 2019-Q3; Q3-2019. Datetime type valid formats (if the values aren’t this format, the function will return an error). 2019/05/22 17:33:45 Example The following example uses the Bike sales dataset. Description Screenshot Suppose you don’t have already the Day attribute in this dataset and you want to extract only the day string from the Date attribute. Add a new attribute, called newday, and type the following formula: and the attribute will be filled with the day value of the Date attribute. You can use the existing Day attribute to double check the results.day(date)
day($"Date")