How to get Date and Time In an Excel. Can anyone help me out of this issue. Please it's urgent for me

Help Studio
1

CopyingData_NewExcelSheet.xaml (11.2 KB)

This is my .xaml file in this after executing flow data is transferring but i am not getting date and time format correctly, can you please help me out from this.

Screenshot (151)
Screenshot (151)1889×736 77.9 KB

In Provided screenshot From AR-AU column i need to get data in date and time format.

2

can you share the excel file or the current format of date in the excel?

3

15-05-2022 02:19:00 AM This is the format

4

Do you need the time or date alone is fine

5

I need both date and time

6

Screenshot (154)
I need like this. the data to be formatted.

7

what is the issue you are facing now

8

First i have shared on screenshot of excel right i.e after execution of flow i got the output the entire data transmitting but this date and time formats i am getting ######## like that.
i.e from column AR-AU. now, i want data as it is shown in the second screenshot. i.e from column AR-AU.

9

if you increase the column width of the excel you will be able to see it

10

Yes i Tried that but there is no Date and Time format only in that its only ###### are present

11

can you share the excel file?

14

Hi @sandhyareddy :smile:
Thank you for the file !
This is the output excel file, may you share with us the file before your bot uses it ?