Forum Discussion
Date Formatting
I would like some assistance creating a date formula. What i require is the following. Planting Date: eg- 01-01-2019 (entered as a date that a crop was planted) Growing Days: (if i set this as a =...
Do you have a harvest date field?
=If(HarvestDate=“”,Today(),HarvestDate)-PlantDate
Or I’d there is a maximum number of growing days (e.g 90), you could:
=PlantDate+Min(Today()-PlantDate,90)
=If(HarvestDate=“”,Today(),HarvestDate)-PlantDate
Or I’d there is a maximum number of growing days (e.g 90), you could:
=PlantDate+Min(Today()-PlantDate,90)
I currently have this
| Field | Area | Crop Type | Planting Date | Growing Days | Desication Date | Days Desicated | Desication type | Harvest Date | Total Growing Days | Todays Date | |||
| Two West | 163.13 | Chickpeas | 1-01-2019 | 115 | 16-04-2019 | 10 | 2litres round up | 1-04-2019 | 90 | 26-04-2019 |
The planting Date and HArvest date will be manually entered as this formala will be mulitplied for severald feilds and those specific date will need to be enter manually. I will try that and see what happens. i just used the 90 days as an example