DateTimeAdd in the Muli-Row Formula

Question

Hello!

I'd like some help with a problem thar I have in my workflow.

Ill try to explain: I have a field with the current month, but i have to change it. I need to keep the current month, but add 1+ month in each row, starting in the current month, restarting in december and stop in the last row.

I was trying to use a multi-row formula, with this sintaxe:

DateTimeAdd([Month],1,Month)

but it doesn't work.

Someone can help me?

Ive attached a sample of my dataset

Thanks!

Example Datetime.yxmd

FláviaB · Answer

Que bom que te ajudou, @EduardoPedraHume. E agora você já sabe que pode vir aqui e ficar à vontade para perguntar em português! Ah, e se a resposta do Ranyaky te ajudou, não esqueça de marcar como solução para ajudar outros usuários que possam estar com a mesma dúvida. 😉

EduardoPedraHume · Answer

Opa, muito obrigado, me ajudou muito!!

Me perdoe, achei que os fóruns eram juntos!!

Ranyaky-Vilela · Answer

Good morning, @EduardoPedraHume.  This is the Portuguese forum, so the question needs to be in PT. There is also the English forum where you can communicate there as well.

About your doubt, try this:

Use the Record ID to generate a number for each line where you will use to add the month, after use Multi-Row Formula:

DateTimeAdd(ToDate([Month]),[RecordID],'month')

Ranyaky Vilela