Wrong date format used in calculated field

Q&A
,
1

formatDate({date},‘yyyy’) I have used this in calculated field where date is in “yyyy-mm-dd” format but I am not able to use these function in visual
Please help

20250813_154116
20250813_1541161920×885 260 KB

2

Hi @Tanu_13

To extract year from date, please use extract function.

Example:

extract('YYYY', {datefield})
3

Hi @Tanu_13,

It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Tanu_13,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you