cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaWu
Impactful Individual
Impactful Individual

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
iAm_ManCat
Super User II
Super User II

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

3 REPLIES 3
iAm_ManCat
Super User II
Super User II

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

SaWu
Impactful Individual
Impactful Individual

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.

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (27,800)