DateAdd not changing date

[Monikk2711]

I am having problems with the Dateadd function. The formula is supposed to add months to the latest update date based on the type of partner. It is adding the day and the month properly; however, it does not change the year.  I am using the following formula:

The result I get is the following:

But instead of 2023 in the follow-up email, it should be 2024. Do you know why this is happening?

Thank you in advance.

[hthpowerapper]

The Syntax Seems off.. also the Date format doesnt seem to be in the corrext format to use in the Text format. Something like this may better suit your solution. 

If(
    _VarPartner.'Partner Type' = "Strategic",
    Text(
        DateAdd(ThisItem.'Latest Update', 6, Months),
        "[$-en-US]mm/dd/yyyy"
    ),
    If(
        _VarPartner.'Partner Type' = "Regional",
        Text(
            DateAdd(ThisItem.'Latest Update', 12, Months),
            "[$-en-US]mm/dd/yyyy"
        ),
        ""
    )
)

[Monikk2711]

Thank you! I changed the syntax to look like yours but the problem persists 😞 

Any other ideas?

[hthpowerapper]

It looks like youre using ";" instead of "," like I had it.. Using the Semi colons doesn't seem to be working for me.. maybe try replacing them with commas?

If(
    _VarPartner.'Partner Type' = "Strategic",
    Text(
        Date(
            Year(ThisItem.'Latest Update'),
            Month(ThisItem.'Latest Update') + 6,
            Day(ThisItem.'Latest Update')
        ),
        "[$-en-US]mm/dd/yyyy"
    ),
    If(
        _VarPartner.'Partner Type' = "Regional",
        Text(
            Date(
                Year(ThisItem.'Latest Update'),
                Month(ThisItem.'Latest Update') + 12,
                Day(ThisItem.'Latest Update')
            ),
            "[$-en-US]mm/dd/yyyy"
        ),
        ""
    )
)

or try something like...

[Monikk2711]

No 😞 , commas do not work for me, I believe it is because of the language in the computer. I have to use semicolons everywhere instead of commas.

I tried that alternative and nothing. I am thinking it could have something to do with the way in which the Latest Update column is set maybe? This is what I have on the previous screen:

ClearCollect(ColPartners;'Partner Integration Details');;
ClearCollect(ColUpdate;'Partner Integration Email Contact History');;
ClearCollect(colGroupedPartners; GroupBy(AddColumns('Partner Integration Email Contact History';"Partners";PartnerName.Value);"Partners";"LastUpdate"));;
ClearCollect(colLastUpPart; AddColumns(colGroupedPartners;"Latest Update";Max(LastUpdate;Date)));;

Set(_VarPartner; ThisItem) ;; ResetForm(EditPartnerForm);; EditForm(EditPartnerForm);; Navigate(ViewPartner)

[hthpowerapper]

Thank you for explaining the Semi Colons/Comma Difference to me! For future posts maybe including your code as a "code sample" will help more users help you because it will be easier for them to replicate the code on their devices. Good Luck.

[Monikk2711]

You're welcome! and thank you for this, I did not know about this option. I just changed it in my last post and will use it in the future!

[Monikk2711]

In case anyone experiences the same issue, I solved the problem by changing the object from a text box to a date picker. It was probably not being recognised as a date before. I used the formula below and it works well now. I also changed the language in the computer, so it uses commas now 🙂

If(
    _VarPartner.'Partner Type' = "Strategic" || _VarPartner.'Partner Type' = "Regional", 
    DateAdd(LookUp(colLastUpPart, Partners in _VarPartner.Title).'Latest Update',3,TimeUnit.Months),
    DateAdd(LookUp(colLastUpPart, Partners in _VarPartner.Title).'Latest Update',12,TimeUnit.Months))