Hi,

getting really into my new filemaker database, but hitting a few blocks on the way, i would like to convert numbers into dates, in access i used Dateserial to convert it,

for example is there a function to change '2102' to read 'February 2021' so in may database i get yymm as numbers but need to change them into a date

any help would be greatly appreciated

many thanks

In Filemaker, 'February 2021' is not a date. You can convert '2102' to either a text string 'February 2021', or to a specific date - say Feb 1, 2021 - which you can then format to display as 'February 2021'.

how would i go about specifing the date or creating a text string

sorry for the newbie question, feel like im back at the begining again with databases

If you want to go the date route, make the calculation =

Date ( Right ( YourField ; 2 ) ; 1 ; 2000 + Left ( YourField ; 2 ) )

and set the result type to Date. Place the field on the layout and custom-format it to display only the month name and the year.

I pray to the church of comment, many thanks once again, and thank you for the examples they really are helping me out

cheers