You’re offline. This is a read only version of the page.
I have a Dataverse column 'ETA' which is Date only.
I'm using this Table in PowerApp. When I add ETA field, it is shown as Datetime instead of Date only.
Column was created as Date only from the beginning so there is no question of refresh. I haven't changed column settings after its creation.
How should I convert this to Date only? I have 6 such fields in one screen and 2 screens in total (so 12 Date only fields)
Thanks for your help Rimmon!
Hi @Random1232 ,
As far as I can tell, this is not an automatic thing.
The time stored in Dataverse, even if it is of a date-only type, includes the default hours and minutes of 0.
I'm sure you've discovered this when you're using data sources in PowerApps.
That's why I'm suggesting you set the Visible property instead of removing Time directly, because even if the type of the time column is a date-only type, the column value must be in "date + time" form. This is different from SP list, so this results in a time being automatically created when the date-only column is added in the form.
Best regards,
Rimmon
Thank you for the response!
Yes, I can. But I have manage visibility for 3 components (hour, minute, colon) and change the size for the date field. That's four actions per card.
I know I sound lazy, but this is not the only power app I'll be facing issue. Shouldn't this be an automatic thing? or is there a setting to turn this card to Date Only?
Hi @Random1232 ,
If you don't want to show them, you can set the Visible of them to false.
Best regards,
Rimmon
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (