cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yougan
Helper V
Helper V

Although date format updated correctly under the default property it is not reflecting

I have tried to change the date format but it is not working, still I can see the time format. Please find attached screenshot and help. 

4 REPLIES 4
BCLS776
Super User
Super User

Changing the default and its formatting does not remove any controls from that card. The hours/minutes controls you see are a result of the SP list's column allowing date & time instead of date only. You will need to remove those controls and ensure the Update property sends your formatted date back to the SP list. You may want to change your SP list column to reference dates only; otherwise, it will show a 12:00 defaulted time in the list.

 

Also, your formatting statement should probably read: Text(ThisItem.DateJoined,"mm/dd/yyyy")

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
eka24
Super User
Super User

On Update Property of the DateDataCard, change it to:

DateValue1.SelectedDate + Time(Value(Text(Now(),"hh")), Value(Text(Now(),"mm")), 0)

You can also ignore the formula above and chose from the dropdown.
If the hour and minutes are not important, set the visible to false
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
 

Hi BCLS776,

 

I have tried below one, but still it is not reflecting. Please help 

 Text(ThisItem.DateJoined,"mm/dd/yyyy")


@yougan wrote:

Hi BCLS776,

 

I have tried below one, but still it is not reflecting. Please help 

 Text(ThisItem.DateJoined,"mm/dd/yyyy")


Did you make any changes to the controls, the SP List column, or implement any of @eka24 's suggestion? Please share any new output/errors from your app so we know what's going on.

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,812)