I have a canvas app that used information from a SharePoint List. The app has a form for input and includes a couple date pickers. Everything works correctly on the input. I also have a button that generates a block of text that users use to create an email. When generating the text I want the dates to generate as dd mmm yy (12 May 24 for example). I use the following code to convert the text to the format I want
Text(DateValue(IncidentGallery.Selected.'Incident DTG',"en-gb"),"dd mmm yy"). The format generates correctly but the date isn’t accurate. For example, if I input May 6, 2024 on the date picker, when generating my text block it shows as 05 Jun 24. Another date picker is May 9, 2024 and in the text block shows 05 Sep 24. Somehow the month and the day is being switched around and I can’t figure out what the issue is or how to fix it. Thoughts?

I’ve messed around with some other options, and short of changing the date format entirely haven’t been successful. It really needs to follow the dd mmm yy format, so switching to short/long date isn’t an option.