Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,996 questions
@Vijay Rudrasamudram Is your Date column in excel, in text format?
Logic apps excel date issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vijay Rudrasamudram
26
Reputation points
Hi All
We have a logic app running in the production environment which reads from excel which has date columns and converts it to CSV. Excel dates are carried as is ie excel epoch date like 43889. This logic app is scheduled every hour and has been running fine for 2 months, till today morning 00 hrs IST the dates are getting converted to 2020-02-28T00:00:00.000Z with no code changes at our end. Are there are any changes done at the logic apps excel connector level
We are using List rows present in a table and item()?[Date] field. Is there anyway we force it to use the excel default date format
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JayaC-MSFT 5,526 Reputation points2021-01-15T06:42:46.97+00:00 -
Vijay Rudrasamudram 26 Reputation points
2021-01-15T06:54:20.967+00:00 It is date format and not General/number. Previously reading it would give epoch number but now it gives the date. I have written below code
if(empty(item()?['Start Date'])),'',(div(sub(ticks(item()?['Start Date']),ticks('1899-12-30T00:00:00.000Z')), 864000000000)))
for now to convert in to the epoch days when converting to CSV. But i am afraid if suddenly the behavior might go back to what it was before :) that will again break my app.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 46%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shaurya Priyadarshi 1 Reputation point2022-08-12T08:37:11.79+00:00 @Vijay Rudrasamudram I am trying to use your code in my create CSV table for a date column and I was giving your code in the expression field but thats showing as invalid expression
Could you please help me here what could be fix for this
Sign in to comment -