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,
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,
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,
Worked!
Thank you!
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.
Main.xaml (5.3 KB)
Regards,
You are amazing! thank you so much for your help!
Worked!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.