Hi,
I have these functions in two fields:
Field “Dani”:
DATETIME_DIFF({Od},{Do},'days')-1
“Od” field is a date without time, and “Do” is also a date. Sometimes they could be the same dates.
Field “Test date function”:
IF( Smena=1,Dani-1, IF( Smena=2,Dani-1, Dani) )
“Smena” field can be only one of these three numbers: 1, 2 or 3.
Would it be possible to run the IF function of “Test date function” field only if the date range between “Od” and “Do” include Friday(s) and/or Saturday(s)?