How to fetch the month data from other field

#1

hi
i am trying to get the same month in appointment.month according to the date generated in appointment.date ,can u help me with the formula to get exact same month in month from date…

snip1.PNG1074×163 16 KB

#2

For appointment.month, use a Formula field with the following value:

month(field('appointment.date'))

#3

that works!!
thanks mockaroo guys!!