Hi,
I have managed to format this date in my gallery when it pulls through by using the text function and defining how i want it to look. However, this wouldnt work for "date&time" data card.
How do i make this into UK date (dd/mm/yy), not US (mm/dd/yy)?
Thank you! Can't believe it was that simple and that i completely overlooked that. I thought it needed to stay as "shortdate".
Hi @PowerNovice
Please use the Format function in the DatePicker and change the format to:
“dd/mm/yy”
If you have any questions or feedback, please let me know. Have a great day! 😊
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
How does that work when the date is derived from the below (Calendar)? I cant find the "text" attribute in the dropdown. I have tried to use the text function already, and it works fine in my gallery where i'm displaying the contents of this date within a text field.
Hi @PowerNovice
To change the date format in a Date & Time data card, you can use the Text function to specify how you want the date to look like. For example, if you want to display the date as dd/mm/yy, you can use this formula:
Text (ThisItem.Date, “dd/mm/yy”)
Where ThisItem.Date is the name of your date column in your data source. You can replace it with your own column name.
If you have any questions or feedback, please let me know. Have a great day! 😊
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻