How can I add a formatted date to the sprint name in a sprint create automation?

Jenn Sherman

I have an automation that runs every 2 weeks to create a sprint that starts 4 weeks from now so that the backlog always has 2 future sprints in it.  I want to put in the sprint name the start and end dates for the sprint.  So if the sprint starts on 7/1/2024 and ends on 7/14/2024, my sprint name would be "TeamA sprint 4 7/1-7/14".

I created smart value variables to calculate the sprint start and end dates and I use those variables in the "Send web request" action to create the sprint. The automation works to create the sprint but I can't figure out how to add the date to the sprint name field.

Trudy P Claspill

Hello @Jenn Sherman 

A variable is stored as text so your attempt to use the date format function on the variable is not going to work.

I recommend you use the same info you are using to set the variable - now.plusDays(14) - with the alternate format.