How to subtract date with days and get result as date in uipath

Help Activities
, , , ,
1

Hai all,
I have date :20/9/2022
And days to be subtract will be 12(12 is dynamic it may change according to requirements).
I need output 9/9/2022
Thanks in advance…

2

Hi , You may try the below expression in assign activity

Convert.toDateTime(“20/9/2022”).AddDays(-12)

You can use string variable instead of “20/9/2022” and integer instead of -12

Thanks,
Keerthana

3

we convert to DateTime, substract the days and reformat into the needed format

grafik
grafik734×220 45.7 KB

DateTime.ParseExact(strDate, "d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture).AddDays(intOffset).ToString("d/M/yyyy")

feel free to adapt the formats

1 Like
4

This worked but i need to pass variable instead of number -12… and that variable doesn’t contain -12 i.e., negative value it’s just 12

5

no problem just adapt the statement e.g. like:

DateTime.ParseExact(strDate, "d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture).AddDays(- intOffset).ToString("d/M/yyyy")

so we just added - before the variable

6

Hi @cbhavana

You can try this

DateTime.ParseExact("1/9/2022", "d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture).AddDays(-Cint(YourStringVariable)).ToString("d/M/yyyy")

Regards
Sudharsan

7

Yes. I am getting output. Thanks @Sudharsan_Ka

8

Great kindly close the topic by marking the solution @cbhavana

Regards
Sudharsan

9

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