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)
ok another question then
I have now got a number (43581)
MichaelMays wrote:
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)
coming up for feilds that have not yet been planted. anyway to keep that figure ""
| 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 | 112 | 16-04-2019 | 10 | 2litres round up | 23-04-2019 | 112 | 26-04-2019 | |||
| Farm 4 | 320 | Chickpeas | 4-01-2019 | 110 | 19-04-2019 | 7 | 24-04-2019 | 110 | 26-04-2019 | ||||
| 8-01-2019 | 106 | 24-04-2019 | 106 | 26-04-2019 | |||||||||
| 43581 | 26-04-2019 | ||||||||||||
| 43581 | 26-04-2019 | ||||||||||||
| 43581 | 26-04-2019 |
- =If(PlantDate=“”,””,If(HarvestDate=“”,Today(),HarvestDate)-PlantDate)
Thank you so much, Much appreciated michaelMichaelMays