I have a field (Date Type) = “Date Collected” containg a collection date (mo/day/yr. = 07-29-10
.
I want another field to take that date and supply the “Day of Year”.
I’ve looked at the functions, etc., and can’t find a way to do this. The discussion about date indicate that the way it is created is not accurate and therefore they don’t give a solution. However, I don’t care if the result is not exactly accurate, but I need it to be simple and accurate to within a few days.
Can this be done with a calculated field or does it have to be a script?
If it has to be a script, can you please supply me with when that will work since I’m not able to do that.
I want to then be able to sort all my data by the day of year so that I can see which insects are collected during whatever period in year.
Thank you
Hi Glen,
Yes, you can do this with a Calculation field.
Use the formula:
DATE(Date Collected; "D")
Remember on macOS to insert the Date Collected field, double-click on it on the sidebar. And on iOS it has to have square brackets around it like this: [Date Collected].
You can find all of the date formatters that you can use from this website:
https://www.unicode.org/reports/tr35/tr35-31/tr35-dates.html#Date_Format_Patterns
Thanks,
Brendan
.
