This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
I am entering the following formuula but after pressing save the formual appears with the end missing
WHAT I ENTER
IF({1st Sow Date}=BLANK(),"",DATETIME_FORMAT(DATEADD({1st Sow Date},{Min Germ Days},‘Days’)),‘DD/MM/YYYY’)
WHAT APPEARS AFTER I PRE...
Hi,
I cant seem to get this to work…
DATEADD({1st Sow Date},SUM({Min Germ Days},‘Days’))
{1st Sow Date} is a Date field with Manually entered Data and {Min Germ Days} is a lookup field from another table.
The output is the same as the date of {1st So...
You certainly make it easy, you helped me out the other day as well and both pieces of assitance has helped so much in moving my database forward to do things I want it to do with as little effort as possible after the initial data entry.
It is a si...
Thank you
That was the original code I used but it still wouldn’t work on the lookup field but works fine by making the field a rollup.
That is the code I am now using.
Love the way you layed out how the formula works… That has made it easier to. Und...
