Previous amount of month is double value

Help Activities
, ,
1

Hi,

I have to add column month to add data column, this is my variable :

image

and this is the error I got :

image

How to get rid of the duplicate value?

Note : Prev month is 2022/03 (March 2022) because previous AddMonths is AddMonths(-3)

2

@Rhys18

you can append the random number after your column name it will make it unique.
3

I don’t get it, where do I append it? In the data column or which activity? Can you make it details? Thanks

4

@Rhys18

"your column name"+new Random().Next(1,999).Tostring

image

5

But my case is a variable DateTime.Now

6

@Rhys18

have a look on it
->date(DateTime.Now.ToString).ToString("dd/MM/yyyy")

image

it will uniquely identified your column name.
7

image

It’s invalid since I am using CDate

8

Hi @Rhys18,

Do you want it to be added even if it is the same here? If so, you can use below, it will create unique for every second.

previous_moth=DateTime.Now.AddMonths(-1).ToString("yyyy/MM hhmmss")

Regards,
MY

9

No, I want it to be added for every month and year only (June, July, etc)

How come it is double value thou?

10

I couldn’t understand it.

I understand correctly that the error received here is located from the same column name. You want the same again, but do you want a double value next to it? So that’s why I thought that adding seconds instead of a double value wouldn’t matter.

11

No I dont need the double value actually… I need something unique because it’s datetime.now

13

I tested it for you but the clock still comes.

If you are allowed to create a static excel template here, you can create your column-independent data and append it below. Since you don’t add headers, you don’t need columns.

14

To be honest I don’t know what to do… Maybe anyone can help with this kind of thing?