Combine Date and autonumber

[telly]

Hi - I need help on combine my Date and auto-number field in my formula.

I have this formula: [@field:Birthday] + [@field:Age], and it is just adding the age to date.

Thank you in advance.

[SunakoChan]

Hi, 
 For you to be able to combine the two fields not to add, first you need to convert the fields to Text field.

Here is the formula for that: CONVERT(VARCHAR(10), ([@field:Birthday]), 101)+' '+ CONVERT(VARCHAR, [@field:Age])

[telly]

Hi @SunakoChan- Thank you so much, is it possible to get only the month or year of the birthday field?

[SunakoChan]

Hello, 
 You can use this formula to get the MONTH or YEAR of the Date field.

CONVERT(VARCHAR(10), MONTH([@field:Birthday]), 101)+' '+ CONVERT(VARCHAR, [@field:ID]) or CONVERT(VARCHAR(10), YEAR([@field:Birthday]), 101)+' '+ CONVERT(VARCHAR, [@field:ID])

[SunakoChan]

Hallo,
For additional information for  converting the Date/Time field and for getting the month and year  check this link: 
https://stackoverflow.com/questions/74385/how-to-convert-datetime-to-varchar
https://howto.caspio.com/function-reference/