Power Apps / DB in Excel date format as text

[Esthela]

I developed an APP in Power APPS using Excel as database, I know my mistake. I'm migrating now to a Sharepoint list BUT... some dates were stored as text and I don't know how to fixed to load the correct data in SP. Please help!!!!

[poweractivate]

@Esthela 

If you use Excel data source it stores it like this

Check if below formula converts that bizarre looking number to a Text version of the Date Time

//psuedocode - change YourDateField_Value to what's appropriate for you - this is where your number like 44840.09375 goes, for example

Text(
     DateAdd(
          DateTimeValue("1899-12-30 12:00:00 AM")
         ,RoundDown(
               (Value(YourDateField_Value) * 86400)
              ,0
          )
         ,TimeUnit.Seconds
     )
    ,ShortDateTime
)

 Does it work @Esthela ?

Also check the below thread in case it helps for more context and information:

Date shown as number string instead of date 

[Esthela]

Thanks @poweractivate 

I'm sorry, possibly I am too inexperienced to understand what you are suggesting. I wrote your code on the [Text Property] of the [Title] of the [gallery] and the results were weird. I have a mixed data; some were store right some were stored as bizarre numbers.

Let me try to explain myself again: I want to export the data that I already collected in Excel to a share point list that is working as the database linked to the app instead of the spreadsheet.

I don't know how to recover the wrong dates in Excel to fill the SP list.

😞