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

Unmodified standard (view/edit) form datacard for DateOnly CDS field shows time as well

Please be so kind as to read my full post before responding.
Thank you for your consideration.

As a preparation for a PowerApps workshop, I (re)did the current "App in a Day lab" excercises.
http://aka.ms/appinaday
In lesson 2
PAHandsOnLabContent\02-Common Data Service for Apps Lab Manual.pdf

I noticed that the default, standard, unmodified, Display Form for a CDS DateOnly field still shows a time as well, and the data type seems to DateTime.
The result looks like this, including a time:
image.png

As far as I understand, according to the course pdf, I should be getting a pure date field instead:

image.png
The field is set up as DateOnly

image.png

The used display form is, as mentioned, unmodified, with data cards still locked
image.png


Session ID: 279a5d39-9033-46ce-9d22-290657c53648
PowerApps 3.19042.26

My question:

  1. How do I get the Data Card for Request Date to only show the Date?
  2. In particular: Do I have to unlock the data card to deviate from the default to show only the date for a DateOnly field?
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Unmodified standard (view/edit) form datacard for DateOnly CDS field shows time as well

Hi @SaWu

 

If you unlock the Label for the date (DataCardValue25 in this case) and change its value to:

Text( DateTimeValue(Parent.Default), "[$-en-US]dd/mm/yyyy")

..Then it will display only the date

 

PowerApps Date fields on forms are a DateTime Value as indicated by your screenshot:

image.png

 

Cheers,

ManCat




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!
3 REPLIES 3
Super User
Super User

Re: Unmodified standard (view/edit) form datacard for DateOnly CDS field shows time as well

Hi @SaWu

 

If you unlock the Label for the date (DataCardValue25 in this case) and change its value to:

Text( DateTimeValue(Parent.Default), "[$-en-US]dd/mm/yyyy")

..Then it will display only the date

 

PowerApps Date fields on forms are a DateTime Value as indicated by your screenshot:

image.png

 

Cheers,

ManCat




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!
SaWu
Level 8

Re: Unmodified standard (view/edit) form datacard for DateOnly CDS field shows time as well

Hi @iAm_ManCat 

Thanks for solution in the sense that it gives me what I want.
It appears strange to me though, that the default (locked) DataCard settings for DateOnly fields, confusingly for me, show a time as well.

Thanks,
    Sa.

Super User
Super User

Re: Unmodified standard (view/edit) form datacard for DateOnly CDS field shows time as well

You're welcome, glad to help Cat Very Happy

 

.. And yes, the CDS entity is called DateOnly (even though this is likely a date with a 12:00 time that is set to only display the date), so it's an ambiguous case in that PowerApps uses a DateTimeValue to present it.

 

Happy to help out if you have any further issues with this kind of thing going forward - just raise a new request and either I or one of the others on the forum will be able to help Cat Happy




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 422 members 5,016 guests
Please welcome our newest community members: