I have a input as 11/02/2019 which is 11 th month 02 date.
I need to get the output as 11/01/2020
I have to get the output as same month but 1 date before from the output.
If adddays 365 for some time I am not getting the expected output…
use.Add(-1) to get todays date minus 1
as @fayis.cm example using → .addDays(-1) will give diffrent result format
please refer to this
I am trying to subtract 3 days from the current system date. from the below syntax,
Can anyone advice how to solve this and may I know can I use that syntax in the
“=IF(ISNA(VLOOKUP(A2,‘18-01-19’!A:D,1,FALSE)),”“New Deal”","“Old Deal”")"
Instead of hardcoding date in the vlookup formula can I use dynamic value ?
Thank you very much in advance
Try the below expression
Have a view on the link for more information
Hope it will help you.
Instead of adding addyear (1)
Need to pass current t year
Shall we pass datetime.now.year?
Try this below expression
Hope it will work
If it is work mark the appropriate post as solved. it will help for other user
The DateTime.AddYears() method used to add the specified number of years to the value of this instance. we can only pass integer values , which will increment years from the current year.
if you want to subtract years, then use a negative value.
You can see the result you need
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.