Add days

Hi, Team!

Please help me. I have a specific date : 19.08.2020 and I want to add 60 days to find the due date.
How can I do that?

Thank you,

1 Like

Hello @LZlz,

Good day

Cdate(“19.08.2020”).AddDays(60).ToString

You can try the above method

cheers
@LZlz

Hi,

Can you try the following expression?

DateTime.ParseExact("19.08.2020","dd.MM.yyyy",nothing).AddDays(60).toString("dd.MM.yyyy")

if you need DateTime type, the following will work.

DateTime.ParseExact("19.08.2020","dd.MM.yyyy",nothing).AddDays(60)

Regards,

I tried, but appeard the message from below :

Worked!
Thank you!

1 Like

and because the due date is 18.10.2020, I should move the invoice in folder “10.2020”/ subfolder “19.10.2020” (because 18 is the closest to 19; if the due date would’ve been 20.10.2020, then I should move the invoice in folder “10.2020”/subfolder “22.10.2020” - the payment days being only Monday and Thursday)

Do you have any idea how I could do this?

Thanks in advance,

Hi,

the payment days being only Monday and Thursday)

Hope the following helps you.

img20200831-4

Main.xaml (5.3 KB)

Regards,

You are amazing! thank you so much for your help!
Worked!

2 Likes

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