cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FelipeCaru
Level 8

Now() date format

Hello all,

I have a question regarding Now().

I am saving an editform and when it saves, in a log it saves the time when it was saved as Now(). However, it is saving as US format (mm/dd/yyyy). The "Update" property of the card that has the "last modified at" value is "Now()". What I want to know is, how can I make it so when it saves to the log, it saves as Now()  but with format of "dd/mm/yyyy"?

I tried using in the Update of the datacard the following: "Text(Now(), "dd/mm/yyyy hh:mm AM/PM")" however it did not work, instead of, for example, showing 22-4-2019; it said "10-4-2020"

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Now() date format

@FelipeCaru 

If the column you are saving the date to is a Date column, then you will not be able to change the format of it.  Date columns save dates in only one format...a date serial number.  It is up to the "viewer" (i.e. the application) to convert the date to a regional date.

Keep in mind that PowerApps does some strange things with dates...There is no real sense of an invalid date in PowerApp.  For example 31 Feb will not flag as an invalid date...instead it will get converted to 3 March.  That is most likely what you saw with the 22-4-2019.  It took 2019, added 22 months to it (Oct/10) and then 4 days - thus 4 Oct 2020.

So, again, if it's a date column you're dealing with - just store the date.  It is up the the viewing of it to convert to regional values.

 

I hope that is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Now() date format

@FelipeCaru 

If the column you are saving the date to is a Date column, then you will not be able to change the format of it.  Date columns save dates in only one format...a date serial number.  It is up to the "viewer" (i.e. the application) to convert the date to a regional date.

Keep in mind that PowerApps does some strange things with dates...There is no real sense of an invalid date in PowerApp.  For example 31 Feb will not flag as an invalid date...instead it will get converted to 3 March.  That is most likely what you saw with the 22-4-2019.  It took 2019, added 22 months to it (Oct/10) and then 4 days - thus 4 Oct 2020.

So, again, if it's a date column you're dealing with - just store the date.  It is up the the viewing of it to convert to regional values.

 

I hope that is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

FelipeCaru
Level 8

Re: Now() date format

@RandyHayes 

Aye, it was helpful. I decided to download the log from the onedrive it is saved at, and saw that indeed the places where date was stored was not formatted as date, thus me having those problems. Thanks again!

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,306)