Hi there,
I have a date in this format, 20220824
I am trying to convert to a date like 24-08-2022. I can't format as a date as its not valid, so I was trying to split it into dd, MM, yyyy so I can then concat with '-' to get 24-08-2022.
Split doesn't seem to let me choose the amount of characters to count.
Left and right I get the error
Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template function 'left' is not defined or not valid.'.
I am trying
Left('20220823',4)
Left(20220823,4)
Is there a better way of doing this please?
Thanks 🙂
Hi @NeonThunder,
Below is a list of all the string functions available:
In your setup I would use the substring function.
substring('<text>', <startIndex>, <length>)
Try:
substring('20220823',0,4)