Richard-B
New member
- Local time
- Today, 11:15
- Joined
- Dec 28, 2021
- Messages
- 4
OK a normal year has 365 and a leap year 366. If you want to smooth your data in periods similar to weeks that relate to the biological year instead of the commercial week, which has either 52, 53 and every 30 years a 54 weeks. If you use 7 day periods (because people relate to weeks) you end up with a problem what to do with day 366 (ie 31st of December) and leap years. Some people have used 5 day periods because it is divisible into 365.
My solution to the issue is to use a table with day/month (missing out the Year) this becomes a text with a period number (biological week).
However I have come to this solution a bit late.
I have added a text field to my main table (Field Notebook) "dd/mm" (call "DayMonth")
To populate this field using the "Date" (format = Date) from the "Field Notebook" I was trying to use an append query and failing.
I convert the date using - Week: Format$([Date],"dd/mm")
However I am doing something wrong. Can anyone help me
My solution to the issue is to use a table with day/month (missing out the Year) this becomes a text with a period number (biological week).
However I have come to this solution a bit late.
I have added a text field to my main table (Field Notebook) "dd/mm" (call "DayMonth")
To populate this field using the "Date" (format = Date) from the "Field Notebook" I was trying to use an append query and failing.
I convert the date using - Week: Format$([Date],"dd/mm")
However I am doing something wrong. Can anyone help me