Date field

[sowmi]

Hi,

I have  a field with complete date and second field with only month ,Now i need a new field with subtract (first field ,second field).for example:

First Field                   second Field                   required o/p(  new Field)

08/31/2022                             4                                   04/31/2022

04/28/2021                             2                                  02/28/2021

TIA

[Vegar · Accepted solution]

Try using Addmonths() function.

Addmonths([First field], - [Second field]) as [New field]