Power Platform Community Forum Thread Details

I have created an additional column in my sharepoint list named Age, this column is a calculated column that needs to show the Age (days) how old a purchase is and this is based upon the order date. The formula that I used is this:

=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy"))-DATEVALUE(TEXT([Order Date],"mm/dd/yyyy"))

In my SharePoint list the Age is showing the correct number of days, in addition, the sorting works perfectly, but when I add this new column to my Datatable in my power apps application that column is not showing correctly, this is how it is formatted:

I also noticed that when I expect the data type for the Age column that it is being listed with data type string:

I have tried refreshing the data source but no success with that, I really have no idea why the Age column is not showing up in the correct format?? Any help is appreciated!