cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
praneshJ
Helper III
Helper III

Issue with date picker lagging behind by 1 day.

Hello Experts,

 

I have a entity form on which I have added the date only field, while selecting the date from that date picker on my entity form it is lagging behind by one day.

please see the attached screenshot.

praneshJ_1-1604038416997.png

and the record getting inserted for previous date, I am facing the similar issue when I am having the date only field in my some other entities as well.

 

Any help on this is really appreciable!!

 

Regards,

Pranesh

 

3 REPLIES 3
OliverRodrigues
Super User
Super User

Hi, back in the CDS solution, make sure both Data Type and behavior of your date fields are set to Date-Only:

OliverRodrigues_0-1604234324186.png

 




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.

Power Apps Portals Super User


Oliver Rodrigues


 

v-bofeng-msft
Community Support
Community Support

Hi @praneshJ :

I guess your problem is caused by the time zone.

For example, if you save UCT time to CDS, and then use the datapicker control, its DateTimeZone property value is DateTimeZone.Local. The time it displays will be based on UCT time plus date offset (Time zone offset).

I have two solutions for your reference:

Soltuion 1:

Set the dropdown control's default property to

 

DateAdd(Parent.Default,-TimeZoneOffset(),Minutes)

 

 Soltuion 2:

Set the dropdown control's DateTimeZone property to

 

DateTimeZone.Local

82.gif

 

Best Regards,

Bof

v-bofeng-msft
Community Support
Community Support

Hi  @praneshJ :
Has the problem been solved?
Is there anything else I can help?
If this post helps, then please consider Accept it as the solution to help others.Thanks
Best Regards,
Bof

Helpful resources

Announcements
May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

Carousel News & Announcements 768460.png

What's New in the Community?

Check out the latest News & Events in the community!

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Top Solution Authors
Users online (1,313)