Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure: Compare dates in Data factory

Data factory doesn't have a built-in date difference function. I want to compare lastModified date and utcnow in if condition activity. How can I achieve it?

@greaterOrEquals(activity('Get Metadata1').output.lastModified, '2015-03-15T13:27:36Z')
like image 489
gabi Avatar asked Jun 12 '18 06:06

gabi


1 Answers

You can use the ticks function to convert it to integer. Logic Apps function reference for Ticks

The ADF UI may show a warning about it not being a recognized function, but ADF is actually using logic app expressions so it will succeed if you debug or trigger the pipeline.

like image 168
Fang Liu Avatar answered Sep 18 '22 23:09

Fang Liu