Add time to current time and add date if necessery

Help
1

Hi All,

I need to add 2 hours to the time below and incase if the time is 22:00 or more to add one more day to the date.
01.07.2019 17:44
The above is a string variable.
Any one know how to do this? Many thanks

1 Like
2

Fine if the input is
Str_date = “01.07.2019 17:44”

Then
str_date_output = If(Convert.ToInt32(Split(Str_date,” “)(1).ToString.SubString(0,2))>=22, DateTime.ParseExact(Str_date,”dd.MM.yyyy HH:mm”,System.Globalization.CultureInfo.InvariantCulture).AddHours(2).ToString(“dd.MM.yyyy HH:mm”),str_date)

Cheers @tra_my_Tran

3

Hi,
Convert your string value to datetime value first:
datetimevar = DateTime.ParseExact(“01.07.2019 17:44”,“dd.MM.yyyy hh.mm”,CultureInfo.InvariantCulture)

Next use methods of datetime class to achieve the desired.

See DateTime Struct (System) | Microsoft Learn for more

Cheers

4

Hi @Palaniyappan,
I tried but it s not working, can you give me a demo?
Thank you so much :slight_smile:

1 Like
5

Fine
here you go with a xaml
hope its resolved
time.zip (9.5 KB)

Cheers @tra_my_Tran

6

Hi @Palaniyappan,
Thanks for your support, just tried your demo :slight_smile:
however i wanted is like:
if the text is “11.09.2017 13:20” then i want result is “11.09.2017 15:20”
If the text is “11.09.2017 23:00” then i want the result is “12.09.2017 1:00”
Is it possible to fix like that?
Thank you so much :smiley:

7

hi @tra_my_Tran,

lets take,
strdate1 = “11.09.2017 23:00”

  1. Then, take 1 assign
    date1(DateTime) = DateTime.ParseExact(strdate1,“dd.MM.yyyy HH:mm”,System.Globalization.CultureInfo.InvariantCulture).AddHours(2)

  2. writeline —> date1.ToString(“dd.MM.yyyy HH:mm”)

Don’t worry about the date, it’ll change automatically, because here we’re converting that string into DateTime format and adds 2 hours in that date using datetime method called AddHours, So after adding 2 hours date will automatically change.

3 Likes
8

Hi @samir,

Thanks a lot, it s working for me ^^

9

Hi @tra_my_Tran,

Try the below code
Create varaible dateVar as datetime
Assign following code using assign activity
dateVar = DateTime.ParseExact(“11.09.2017 13:20”, “dd.MM.yyyy HH:mm”,null);
dateVar.AddHours(2).ToString()

1 Like
10

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