Return to FileMaker.com
How to Extract a date from a number ( day of year)
I have a code on merchandise that represents the day off the year in was packaged.
Ex: 4 would be jan 4th. Lest say I have a number field in which I enter the code. How would i extract that code to get a date result, in this ex: get Jan, 4 20_ _ ?
Thanks to who ever helps me on this one!
Date ( 1 ; 1 ; SpecifiedYear ) + DayOfYearField - 1
Select "date" as the calculaiton field's return type.
"SpecifiedYear" can be a number field where you specify the year or you can replace it with Year ( Get ( CurrentDate ) ), if you always want to use the current year.
Retrieving data ...