reformatting a date

[gandi]

hello I have a puzzling problem that I can not get around. I am based in the UK. 

I have a API returning a date in the following format YYYY-MM-DD.   when i set a date field with this it brings up a "?". this issue I think is that the feild is maybe no configured properly or a date sell will not accept that format.

 

the for matt I want is DD/MM/YYYY. so I made a let function. the problem I am having is the MM is sometimes a single digit. I think I need sleep lol. any ideas. is there a simpler way of just formatting the field.

 

hope this makes sense

 

[comment]

If your file is using the d/m/y date format, then you must enter dates in this format too. To convert a date you receive as YYYY-MM-DD, you can use:

Date ( 
Middle ( ReceivedDate ; 6 ; 2 ) ;
Right ( ReceivedDate ; 2 ) ;
Left ( ReceivedDate ; 4 ) 
)

Use this formula to set your date field. Note that you can format the field to display the date in any format you like.