Calculate time left in sprint with smart values

[Chris Fortmueller]

I am trying to create an automation rule in a software project that sends an email with some information about the current sprint.

Specifically, I would like to include information about the time left before the end date of the sprint.

I have tried the following to do this, according to https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/ and https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/:

{{now.diff(sprint.endDate).days}}  

{{now.diff(sprint.endDate.jiraDate).days}}

{{now.diff(sprint.endDate.jiraDateTime).days}}

However, none of these give a result (see screenshots of automation rule and resulting email). How would I get this to work?

[Joe R.]

Also interested in an answer to this question