Formula for year

[Dana_Hiatt]

How do I create a formula to add only the year in primary column? I am using Datetime_Format (Date, ‘YYYY’)

[Jeremy_Oglesby]

It looks like you are using the correct formula. If you primary field is a Formula field, then it should look like this when properly formatted in the field options:

DATETIME_FORMAT(Date,'YYYY')

[Elias_Gomez_Sai]

You also have the YEAR() function, simpler.

[Dana_Hiatt]

Do I just enter it into the formula as YEAR ()?
Dana Hiatt, LPC
Licensed Professional Counselor
Mitigation Specialist
2025 Jefferson Oaks Dr
Rural Hall, NC 27045
M (336) 986-2257
F (704) 220-0694
danaahiatt@gmail.com

This electronic mail transmission may contain information that is confidential, privileged, proprietary, or otherwise legally exempt from disclosure. If you are not the intended recipient, you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please delete this message and any attachments from your system without reading the content and notify the sender immediately of the inadvertent transmission. There is no intent on the part of the sender to waive any privilege that may attach to this communication. Thank you for your cooperation.

[Dana_Hiatt]

When I put in Year () or DATETIME_FORMAT(Date,'YYYY’). I get #ERROR! for the entire column. It will not let me add anything to the cells in the column. Do you have any idea what I am doing wrong?

Thank you for your help,

Dana

Dana Hiatt, LPC
Licensed Professional Counselor
Mitigation Specialist
2025 Jefferson Oaks Dr
Rural Hall, NC 27045
M (336) 986-2257
F (704) 220-0694
danaahiatt@gmail.com

This electronic mail transmission may contain information that is confidential, privileged, proprietary, or otherwise legally exempt from disclosure. If you are not the intended recipient, you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please delete this message and any attachments from your system without reading the content and notify the sender immediately of the inadvertent transmission. There is no intent on the part of the sender to waive any privilege that may attach to this communication. Thank you for your cooperation.

[Dana_Hiatt]

Ok. I just did a test column and it works. I was entering it into the first column of the spreadsheet so maybe that was the issue.

Dana

Dana Hiatt, LPC
Licensed Professional Counselor
Mitigation Specialist
2025 Jefferson Oaks Dr
Rural Hall, NC 27045
M (336) 986-2257
F (704) 220-0694
danaahiatt@gmail.com

This electronic mail transmission may contain information that is confidential, privileged, proprietary, or otherwise legally exempt from disclosure. If you are not the intended recipient, you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please delete this message and any attachments from your system without reading the content and notify the sender immediately of the inadvertent transmission. There is no intent on the part of the sender to waive any privilege that may attach to this communication. Thank you for your cooperation.

[Dana_Hiatt]

Can tell me the formula to use to calculate age? I have a column with my clients date of birth and want an additional column that will show his age at the different events in his life.

Thank you for all of your help,

Dana

[Elias_Gomez_Sai]

You have DATETIME_DIFF():

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

[Elias_Gomez_Sai]

Dana_Hiatt:

Ok. I just did a test column and it works. I was entering it into the first column of the spreadsheet so maybe that was the issue.

Spreadsheet? You mean Table? You can use Formulas in the Primary Field (first column), but you need to set it as Formula field type first :thumbs_up:

[Dana_Hiatt]

Thank you for your help. I have reviewed the information below but I still do not understand the formulas. If I use DATETIME_DIFF(): Do I put the columns of each in brackets? so it would be DATETIME_DIFF({Birthday}{Event},’age’). Do I need to have DATETIME_FORMAT in front of that?

Thank you again for your help,

Dana