Calculate week start and end with Math formula

[SHRUTI87]

I have date column and have extracted day of the week. but I am not able to extract the start date of the week from these two columns via Math formula as I have one Date type and other Integer type.

Kindly suggest.

[mlauber71]

@SHRUTI87 there is this suggestion by @webstar:

How to get date of start of the week based on date column

Agree with above - I used the following seq. to get at your problem create a date and time range fixed for 1 day extract date and time fields to get day of week number and day of week name (really just need number) Rule engine $Day of week (number)$ =1 => 1 $Day of week (number)$ =2 => 0 $Day of week (number)$ =3 => -1 $Day of week (number)$ =4 => -2 $Day of week (number)$ =5 => -3 $Day of week (number)$ =6 => -4 $Day of week (number)$ =7 => -5 appending a new column called Start_ind…

[HansS]

Hi @SHRUTI87

Or / and see this wf
Calculate week start and end with Math formula.knwf (24.0 KB)

gr. Hans