Growers Network was created as a resource for adults in the cannabis industry.

Please verify your age to enter.

ISO 8601 Week Function Date

Here is the data for a perpetual scheduling function by ISO 8601 Weeks
Calendar starts

DATE DOFM DOW ISOWeek
2007-01-01 1 1 1
2034-12-31 31 3 52

ISOWEEK Perpetual Function data.csv (195.1 KB)

Have fun and load this anywhere your want for scheduling by week and converting to a date for accounting.

So your full batch id is = (date + ISOWeek + Your Batch Number (your batch number should be serial number) 1,2,3,4…)
example:
2019-01-01W01B000001
2019-01-01W01B000002
2019-01-01W01B000003
2019-01-08W02B000004
2019-01-08W02B000005
2019-01-08W02B000006
2019-01-08W02B000007

I generally refer to the crop as

Week 1 Batch 3
Week 2 Batch 6

This whole method lets me quickly find and compare crops year to year batch to batch

This keeps all your number is a row without padding for data

@Farmer_Dan, @fdousty, @Growernick

1 Like