Date Format from Excel Converter

Help Activities
, ,
1

Hello everyone,
I have an issue with strange behavior.

I have and excel table with dates, stored in Date Format “MM/dd/yyyy”
After converting them to String Format, I get some on them in this type ‘44244’

I tried with this assign - DateTime.FromOADate(ConvertToDouble( in_TransactionItem(“Scheduled Days”).ToString)).ToString(“MM/dd/yyyy”)
however, it gives me the next day after the date.

Would anyone recommend any other solution?

2

Hi @zhasmina.dimitrova

Assign the DateTime variable to a new string variable:

Assign activity: strDate = myDateTime.ToString()

Note that the myDateTime variable should be of DateTime datatype, and strDate should be a string variable to store the converted DateTime value.

Hope it helps!!

3

Hi @zhasmina.dimitrova
Try this

Convert.ToDateTime(YourDate).ToString(“dd/mm/yy”)

(YourDate is the variable i have created to store the values)

4

thank you, but unfortunately, none of them works

5

@zhasmina.dimitrova
Try this

Convert.ToDateTime(CurrentRow(“Date”).ToString).Date.ToString(“dd/mm/yy”)

6

Still not…

7

The date is stored in excel in Date format. When I convert it to string, it gives me the random number… when I convert it with parse exact–> gives me the next day

8

resolved the issue with sql query

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.