0

Text / Date Functions
I need to have a field that calculates 342 days added on to ‘breeding’ date entered in a table -
So if someone enters 1/1/2016 for a breeding date
I need the foaling date to show: 12/8/2016 (342 days later)
is there something like (Breeding_Date)+342(days)
So if someone enters 1/1/2016 for a breeding date
I need the foaling date to show: 12/8/2016 (342 days later)
is there something like (Breeding_Date)+342(days)
Like Follow
71replies
-
Andrea,
---
if ‘Fattura N.’ != null then
styled(“Fatturato”,"","","moneybag")
else
if ‘Data ricezione’ != null and ‘Data invio a fornitore’ != null and ‘Data evasione fornitore’ != null and ‘Data invio a cliente’ != null then
styled(“Fatturabile”,"","","money")
else
styled(“Non Fatturabile”,"","","forbidden")
end
end
---
for explanation
styled("my Text","Background Color "," Text Color "," Icon ")
regards
Leo -
Hi, I know that using Ninox DB in the cloud with Firefox, the Date fields have a problem: the calendar that opens to choose a date does not close after choosing it. This in every Date field. I tried on another pc with Firefox (updated) and has the same problem. With other browsers it works correctly. Could you check? thank you.
-
Hello Jayaraj,
Two ways to capture this:
1. Using the record creation timestamp in Ninox. Get this by using "_cu" in a formula f(x) field.
2. Use formula, 'Entry Time' := now() on the trigger of the field whose entry you wish to capture. Here 'Entry Time' is a Date/Time field to store the creation time.
Regards,
Sakshi-Ninox