Pipeline : Run activity on Monday to Friday between 9am and 7pm

[Joschko]

Hello,
I would like to run an activity in the pipeline only from Monday to Friday from 7:00 to 17:00.
I have added an If Condition Activity for this purpose.
I use the following expression for the false part to exclude Saturday and Sunday.

@OR(
equals(dayOfWeek(convertFromUtc(utcNow(),'W. Europe Standard Time')),0),
equals(dayOfWeek(convertFromUtc(utcNow(), 'W. Europe Standard Time')),6)
)

I don't know how to do this for the hours 7:00 to 17:00. The hour function, as in ADF, is not available. Do i miss anything?

Thank you very much for reading

[Joschko]

Hey, thank you. That worked.

Here is the expression to exit (results to true, only monday to sunday between 9am and 5pm):

Please note that line breaks are accepted in the editor but leading to errors when executed.

@or(or(or(equals(dayOfWeek(convertFromUtc(utcNow(),'W. Europe Standard Time')),0),equals(dayOfWeek(convertFromUtc(utcNow(), 'W. Europe Standard Time')),6)),lessOrEquals(int(formatDateTime(utcNow(),'HH')),9)),greaterOrEquals(int(formatDateTime(utcNow(),'HH')),17))

Thank you.

Jörg

[v-cboorla-msft]

Hi @Joschko 

Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[NandanHegde · Accepted solution]

Hey,

You can use formatdatetime function to get the hour details :

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#form...

Something like below :

@formatDateTime( utcnow(),'hh')