Change Date & Time Format on Gallery Text Labels

[BS10]

Hi,

I have a gallery and on each item I have the start time and end time as 2 text labels. However, it is displaying the date as "mm/dd/yyyy" but I would like it to display it as "dd/mm/yyyy". The current text code for the label is ThisItem.'Start Time' ('Start Time') is my column on the list. The date in the SharePoint list is also displaying it as "dd/mm/yyyy". 

Thanks

[poweractivate]

To change the date format for the text labels in your gallery, you can use the Text function along with the desired format string in Power Apps.

For your 'Start Time' label, the formula should be:

Text(ThisItem.'Start Time', "[$-en-GB]dd/mm/yyyy")

The [$-en-GB] part is a locale specifier that follows the Great Britain format for the date. You can adjust this to other locales if needed.

 For your 'End Time' label, you would use a similar formula:

Text(ThisItem.'End Time', "[$-en-GB]dd/mm/yyyy")

These formulas should display the date as "dd/mm/yyyy" as you wanted.

See if it helps @BS10 

[AndrewR1]

To format the date displayed in your Power Apps gallery label as "dd/mm/yyyy," you can use the Text function to convert the date value to a formatted string. Here's how you can modify your label's text property to achieve the desired formatting:

Text(ThisItem.'Start Time', "dd/mm/yyyy")

In this formula, the Text function takes two arguments: the date value you want to format (ThisItem.'Start Time') and the format string "dd/mm/yyyy".

If this helped and resolves your issue can you leave a thumbs up and mark this as the solution?

Many Thanks
Andrew

[SpongYe]

Try this:

Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy")

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

[BS10]

Hi @poweractivate,

Thanks for the fast response, this has worked thank you but I also have the time in the column too. Is it possible to include this as well? 

Thank you!

[SpongYe · Accepted solution]

Hi @BS10 

You need to edit the format:

Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy  hh:mm")​

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

[BS10]

Hi @SpongYe,

Thank you, that's worked. If I would like to add AM or PM on the end, is that possible?

Thanks

[SpongYe]

Hi @BS10 

Then you AM/PM at the end

Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy  hh:mm AM/PM")​

[BS10]

Hi @SpongYe,

Thank you very much! Just one last question if that's ok, not a major thing but before when the date was wrong the time was 4:00 PM but now it's 04:00 PM for example, is it possible to remove that 0 if it's not needed? Just wondered if that's possible.

Thanks again for all the help!