DateTime Format1

Help Studio
,
1

image
image980×598 32.9 KB

can anyone plz solve this error? which is i don’t understand.

2

Hi @Yogita_Gaikwad1 ,
What is input and expect result?
Regards,
LNV

3

image

This is my excel & i want to take StartDate & StartTime from excel

4

Hi @Yogita_Gaikwad1

Do you want to take only time in Start Time or whole thing in the Start Time Column?

5

I tried both vaule but not work & i want only take time in start time

6

Okay @Nguyen_Van_Luong1

In that case for giving time you have to provide the below expression in Start time field.

DateTime.ParseExact(CurrentRow(6).toString, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).toString("HH:mm:ss")

Hope it helps!!

7

image
image1306×194 11.8 KB

8

Then it better to change the format the cells in the excel. To change the format of StartTime Column values use the Fomat cells activity first.

When open the set format, change the Data Type to Time and Time format give the format like HH:mm:ss like below.
image

Note - You have to use the Format cells activity inside the Use excel file activity.

Hope you understand!!

9

image

this is right ?

image

then in start time what shoud i give
can u do in my workflow?

10

Hi @Yogita_Gaikwad1

**Note**:dateTimeValue and convertedDate are of datetime datatype variables.

Assign dateTimeValue= DateTime.ParseExact(CurrentRow(6).ToString, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
Assign convertedDate=DateTime.ParseExact(CurrentRow(5).ToString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)

image
image870×1835 75.9 KB

Hope it helps!!

11

can u plz send workflow of the screenshot?

12

I already attached the scrnshot

13

I am not able to see screenshot clearly

14

image
image870×1835 75.9 KB

15

New folder.zip (9.8 KB)

can u do in my workflow?