Concevrt string into date fromat

Help
1

hi,
I am getting the received timestamp from mail activity but its stored in string variable. I am unable to subtract from DateTime.Now output because its datetime .

let me know how we can do it

2

Hello,

please try to use this expression:

Date.ParseExact(YourString,“dd/MM/yy”,System.Globalization.CultureInfo.InvariantCulture)
“dd/MM/yy” - desribes the format in which date was saved as string

Then you can substract two DateTime variables.

Regards

3

hi,
Datetime.Today.AddYears(-1).ToString(“MM/dd/yyyy”)try to use this syntax for subtracting

Regards,

4

hi,
I will try above one just clarity from mail I am getting date in (05/03/2019 11:01:16) this format

5

getting validation error.

6

At what stage exactly? Could you go into details or attach workflow?

7

Please find screens of my example workflow:

image
image479×518 12.4 KB

Output:
image

Regards

1 Like
8

CalculateTimeDiff.xaml (5.2 KB)
hi,

Uploaded the workflow ,please check

9

Please make variable currentTM in type DateTime, not Date.
Refer to my post above. (With usage of conversion of D2 variable)

Regards

10

I am reading that values from excel/mail received timestamp which gives output in string.
If change the type it will give error on excel values store.

11

Read this value from Excel as string, and save it with conversion (which I have posted above) to a new DateTime variable. And this new variable subtract from DateTime.Now

Or simply do:
DateTime.Now - Date.ParseExact(D2,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)
where D2 is your string variable from excel file.

Regards

12

Capture
we are getting the above error

14

Hey @kiranh

Try This: - CalculateTimeDiff.xaml (4.7 KB)

A TimeSpan value represents a time interval and can be expressed as a particular number of days, hours, minutes, seconds, and milliseconds.
Tt represents a general interval without reference to a particular start or end point, it cannot be expressed in terms of years and months, both of which have a variable number of days.

Regards…!!
Aksh

1 Like
15

AAAH yes timestamp is different with datetime na…very bad…my mistake
Thats great
cheers buddy @aksh1yadav
@kiranh

16

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