C:\Users\YBTQ\Downloads\Alerts.xlsx|||`Sheet1$`
False
1
Alerts.xlsx
Query=`Sheet1$`
Date = [DateTime]
Day = DateTimeFormat([DateTime],'%A')
Week starting from Monda...
IF DateTimeFormat([Today], "%a") = "mon"
THEN DateTimeDiff(DateTimeFormat([Today], "%Y-%m-%d"),DateTimeFormat([Date],"%Y-%m-%d"),"days")<4
ELSE DateTimeFormat([Date],"%Y-%m-%d") = DateTimeFormat(DateTimeAdd([Today], -1, "days"), "%Y-%m-%d")
ENDIF
Custom
IF DateTimeFormat([Today], "%a") = "mon"
THEN DateTimeDiff(DateTimeFormat([Today...
IF DateTimeFormat(DateTimeToday(), "%a") = "mon"
THEN DateTimeDiff(DateTimeFormat(DateTimeToday(), "%Y-%m-%d"),DateTimeFormat([Date],"%Y-%m-%d"),"days")<4
ELSE DateTimeFormat([Date],"%Y-%m-%d") = DateTimeFormat(DateTimeAdd(DateTimeToday(), -1, "days"), "%Y-%m-%d")
ENDIF
Custom
IF DateTimeFormat(DateTimeToday(), "%a") = "mon"
THEN DateTimeDiff(DateTimeForma...
Horizontal
New Workflow3