You’re offline. This is a read only version of the page.
I have a flow that takes appointment dates from a spreadsheet and sends an sms appointment reminder to a user. At the moment it appears serial number format 44307 in the sms rather than date format dd/mm/yyyy can the flow convert this rather than having to edit the original spreadsheet?
The items('List_rows_present_in_a_table')['appmt_Date'] was my approximation of the field you are using. If you hover over the AppmtDate field in your current email the tool tip will show you what it should be.
How do i do that given the setup above. Totally new to flows. The spreadsheet has two date fields which look OK and are in date format but flows must be reading them in as text. One date field is whole numbers the main one and the other has decimal places once you convert to text in excel.
Following up on @Paulie78 's formula, that will only work if the date is a date only field in Excel. Serial dates often include decimal values to represent partial days (time). Since Flow's INT() function can't handle decimal whole numbers I normally recommend using a more involved formula that will convert from decimal whole numbers as well as integers. Yours should be something like this:
Share
Report
All responses (
Answers (
addseconds('1899-12-30',int(formatnumber(mul(float(items('List_rows_present_in_a_table')['appmt_Date']),86400),'0’)))
Something like this:
addDays('1899-12-30', int(44307), 'dd-MM-yyyy')In an actual flow you would probably have something like item()['Date'] instead of 44037 for example. The dynamic date value from excel basically. I've specified the date formatting there also, which you might want to change.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
