How to format a date coming from a webhook and put it in DueDate?

[Mike Saldivar]

We are building an automation with Rippling and have the webhook and data input all working, except Rippling sends dates in the format 4/7/24 for April 7, 2024.

Is it possible to auto-format that and put it into the Due Date formatted YYYY/MM/DD?

Previous answers say to use .toDate but 

{{webhookData.ripplingdate}}.toDate

produces blank output.

Another answer said to use toDate with format but trying to string them together doesn't produce output.

{{webhookData.ripplingdate.toDate("yyyy-MM-dd").format("dd/mm/yy")

According to this page https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

It looks like I'm getting text in the format of shortDate (11/1/79) and need to turn it into jiraDate (1979-11-01)

Is that possible to do on an incoming webhook, and stick it in the Due Date?

[Kai Becker · Accepted solution]

Hi @Mike Saldivar 

you need to passt the format of the value you want to convert not the destination.

Please try the following:

{{webhookData.ripplingdate.toDate("dd/MM/yy").jiraDate}}

[Mike Saldivar]

Thanks this worked perfectly!

I was also able to tweak it to this to get a full date in the Description:

{{webhookData.ripplingdate.toDate("dd/MM/yy").longDate}}

[Andy Rusnak]

Hi Mike, 

Thanks for posting to Community!  I hope you are doing well.  I think you are close on this.  You are correct I believe in that you are getting a string value from the webhook data and need to convert that into a Date Object.  But if I am understanding your scenario correctly I think you would want to use something like this: 

{{webhookData.ripplingdate.toDate("M/d/yy").format("dd/mm/yyyy")}}

 The toDate function is wanting to understand the format of the date you getting in the string, and the format function will convert it to the formatting you desire as an output string.  I tested this using a Text custom field and I used the following: 

{{issue.customfield_10360.toDate("M/d/yy").format("MM/dd/yyyy")}}

This logged out the date '12/11/25' as '12/11/2025' as I would expect.  

Could you give that a go and see if it works for you? 

Best, 

Andy