Skip to main content

Hello,


I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula.


Would anyone know what the formula would be?


Thanks in Advance!

You can use either of these:


YEAR({Date Field})

or

DATETIME_FORMAT({Date Field}, 'YYYY')

Thanks Kamille - You’re Awesome!

You can use either of these:


YEAR({Date Field})

or

DATETIME_FORMAT({Date Field}, 'YYYY')


Thank you for this, how would I go about getting the Month (name not number)  = as similar formula

We organize our reports rollup by month.  I have a manual method right now but I would love to have an automated formula that created JAN/FEB/MAR etc so when I create a report - it prints out the Month Name not the Month Number

Reply


Terms & Conditions