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.
@SHRUTI87 there is this suggestion by @webstar :
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…
2 Likes
HansS
July 1, 2022, 12:10pm
#3
3 Likes
