Add one year to a varible

Help Activities
, ,
1

Hi Team,

I have a cell activity that reads from an Excel file a date and I want to add a month or year to this date so how can I do that

2

@omar_ismail

Please put an input and output

For adding a month:
yourDateVariable = yourDateVariable.AddMonths(1)

For adding a year:
yourDateVariable = yourDateVariable.AddYears(1)

3

it’s giving me an error (Add month is not a member in integer)

4

Hi @omar_ismail

If you want to Add Year:

Year = DateTime..ParseExact(Input,"MM/dd/yyyy",System.GLobalization.CultureInfo.InvariantCulture).AddYears(1).ToString("MM/dd/yyyy")

If you want to Add Month:

Month = DateTime..ParseExact(Input,"MM/dd/yyyy",System.GLobalization.CultureInfo.InvariantCulture).AddMonths(1).ToString("MM/dd/yyyy")

Regards

5

image
image1160×489 14.9 KB

6

Hi @omar_ismail

What is the Output variable type of Read Cell activity, can you specify?

Regards

7

image
image1582×513 22.9 KB

string

8

Hi @omar_ismail

Sorry it was my bad that I inserted two dots:

Check this:
If you want to Add Year:

Year = DateTime.ParseExact(Input,"MM/dd/yyyy",System.GLobalization.CultureInfo.InvariantCulture).AddYears(1).ToString("MM/dd/yyyy")

If you want to Add Month:

Month = DateTime.ParseExact(Input,"MM/dd/yyyy",System.GLobalization.CultureInfo.InvariantCulture).AddMonths(1).ToString("MM/dd/yyyy")

Change the format of date according to yours
Regards

9

Hi @omar_ismail

Or you can even try this way:

image
image717×1040 37.4 KB

Regards

10

image
image1242×234 12.7 KB

same error

11

Hi @omar_ismail

Please pass your Input variable that is OldDate instead of Input.

Regards

12

@omar_ismail

Please put the format of your date if it is “dd/MM/yyyy” or “MM/dd/yyyy”

Year=DateTime.ParseExact(OldDate,"Your Format",System.Globalization.Culturalinfo.InvarientCulture).AddYears(1).ToString("MM/dd/yyyy")
Month=DateTime.ParseExact(OldDate,"YourFormat",System.GLobalization.CultureInfo.InvariantCulture).AddMonths(1).ToString("MM/dd/yyyy")
13

image
image984×466 16.9 KB

same issue

14

@omar_ismail

Please put your excel screenshot

15

Hi @omar_ismail

Please Type CDate(OldDate) there

Please refer the screenshot. The same I have mentioned in that too @omar_ismail

Regards

16

image
image1010×272 15.4 KB

17

@omar_ismail

In imports panel import System.Globalization

And also CultureInfo “I” Should be Capital

18

Hi @omar_ismail

Input:
image

Workflow:

image
image717×1941 85.7 KB

Output:

image
image1016×788 43 KB

Xaml:
Sequence36.xaml (13.4 KB)

Please check the workflow and replicate your process.

Regards

19

@omar_ismail

Is the error gone if it is not gone then cut the expression and simply paste the expression

DateTime.ParseExact(OldDate,"MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture).AddYears(1).ToString("MM/dd/yyyy")
20

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