Calculate the date based on today’s date

[Waka (Andy NG)]

I need some help on calculating expiry date. Let’s says today date is 10-7-2019 and I need the robot to calculate 30days to find out what is the expiry date. Anyone have the code to share ? Thanks

[Jyotika_Halai]

Hi @Waka,

Use the below function:
String1: 10-7-2019
DateAdd(“d”,30,String1)

or

DateTime.Now.AddDays(30).ToShortDateString

[Waka (Andy NG)]

Thanks, can we convert variable string ‘date’ to date time?

[venkatmalla6 (venkat malla)]

@Waka yes we can give like this Datetime.ParseExact(newdate.ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) it will give you the output as date format

[Waka (Andy NG)]

I used the code above and I got an error message ‘String was not recognised as a valid date time’ to put it in datetime data type

I use it in Assign activity

[vikaskulhari]

@Waka

me help on calculating expiry date. Let’s says today date

@venkatmalla6 you can use Convert.ToDateTime(String). Cheers!!

[venkatmalla6 (venkat malla)]

@vikaskulhari you,re right buddy but if the date string is like this dd/mm/yyyy it is not working.it works if the string date is mm/dd/yyyy

[vikaskulhari]

@venkatmalla6, this is happening because of your system date format. you can break your date and rearrange it in any format.

[Palaniyappan (Palaniyappan P)]

Hi Buddy @Waka

lets say we have a variable string with the date value like this
in_date = “10-7-2019”
then to get the 30 days from now
out_date = Convert.ToDatetime(in_date).AddDays(30).ToString(“dd-MM-yyyy”)

This worked buddy

Cheers @Waka

[Waka (Andy NG)]

It is working. Thanks.

[Palaniyappan (Palaniyappan P)]

Fantastic buddy
Cheers @Waka

[Waka (Andy NG)]

@Palaniyappan

My apology. After inserting the code. I got the same error message. Despite that I’ve changed all variables to string.

String was not recognised as a valid datetime

Before the assign, I’ve used get text activity to retrieve in_date.

[Waka (Andy NG)]

I found the solution in this threat as the problem come from UiPath

Guidance on String/DateTime Conversion and String Manipulation

hello, You are facing a problem that I had before, the problem is that UiPath has a cultureInfo by default that does not comprehend that specific format, meaning that it won’t convert it, the solution is to change the culture info for one that does comprehend it, I know is kinda strange that this is the problem, considerating you wrote InvariantCulture as cultureInfo but I had the same trouble to. To change the culture simply write an assign with this: CultureInfo.CurrentCulture = Globalizat…

[Palaniyappan (Palaniyappan P)]

Fine
no worries
say if you have a variable with date value in string like this
in_date = “10-7-2019”
then the output would be
String out_date = Datetime.ParseExact(in_date,“MM-d-yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(30).ToString(“dd-MM-yyyy”)

what we need to concentrate is we need to mention the format of what in_date variable has, to the next format mentioned in Datetime.Parseexact
Datetime.ParseExact**(in_date,“MM-d-yyyy”**,System.Globalization.CultureInfo.InvariantCulture).AddDays(30).ToString(“dd-MM-yyyy”)
as
in_date = 10-7-2019 = MM-d-yyyy
so we mentioned as MM-d-yyyy next to it
if the format of in_date changes we need to mention the format next in the Parsing method accordingly
this worked as well

Cheers @Waka

[katara (kamil haklı)]

Like as calculator.date ?