Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using Addmonths() function.
Addmonths([First field], - [Second field]) as [New field]
Try using Addmonths() function.
Addmonths([First field], - [Second field]) as [New field]