Show date/text depending on the date when flow runs
if(
equals(formatDateTime(utcNow(), 'dd-MM-yyyy'), '11-05-2024'),
'Bank Holiday',
if(
equals(formatDateTime(utcNow(), 'dd-MM-yyyy'), '27-05-2024'),
'Spring Bank Holiday',
if(
equals(formatDateTime(utcNow(), 'dd-MM-yyyy'), '26-08-2024'),
'Summer Bank Holiday',
if(
equals(formatDateTime(utcNow(), 'dd-MM-yyyy'), '25-12-2024'),
'Christmas Day',
if(
equals(formatDateTime(utcNow(), 'dd-MM-yyyy'), '31-12-2024'),
'New Years Day',
'Not a Bank Holiday'
)
)
)
)
)
No Comments