Why are the date time not shown correctly in PowerApps but are correct in CDS?

[jzhang]

Hi, 

I uploaded some data from SQL server to CDS, and the date time field in CDS looks alright (below left). But when I tried to use the field in PowerApps, the date time is show as numbers (below right), and therefore cannot be used to compare with other dates. I haven't found any function in PowerApps to convert the date time format from the right to the left types. Has anyone encountered this problem before, or have any suggest   

[Anonymous · Accepted solution]

Hi @jzhang 

See if this helps:

Text(1564272000000, "dd/mm/yyyy") // 28/07/2019

convert the value of the dropdown using above Text function.

Thanks

[jzhang]

Many thanks! 🙂 If I have a datetime field, but I want to convert it to only date, how can I do that? 'Cos I found I can't actually compare to the time-level, then nothing will match