Using Flow recurrence on SharePoint List Items, I'm able to send emails based on utcnow() expression in the flow. But the expression brings the whole timestamp. I would like to know if we can trim the expression to only give date as result, removing the time from the expression.
Current condition:

if [current date] Greater than or Equal to [utcnow()]
The above expression looks for all the items in the list that are equal to the whole date time stamp.

Would like to know if we can trim the expression to compare only date field excluding time.

1 Answer 1


You can do it like this:


Look at the official documentation about Custom Date and Time Format Strings in Flow

  • 2
    I used this today and we are no longer needed @. And its utcNow (N capital). formatDateTime(utcNow(),'yyyy-MM-dd') will work. Nov 27, 2018 at 9:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.