Text / Date Functions
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)
71 replies
-
Hi Leo,
I'm also interested in the day, month, year format when I calculate the difference between two dates. Your link does not work.
thx -
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!
Is there a way to attach the pdf file created with the print button in an email opened by an email field?
thx!
Andrea -
Hi Andrea,
we have this feature planned.
Best regards, Alex -
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.
-
Hi Andrea, thanks for reporting this. Is it on a Windows PC?
Best, Frank -
Yes the problem si on Windows PC. Instead using Firefox on mac it works well.
-
there is a list of the name of icons?
-
-
Greetings,
I believe you have a function that returns a day of the month (or perhaps more generally, a number) in the format "nth" (e.g., "1st", "2nd", "3rd"). Am I remembering it correctly? I can't remember the name of it so am having difficulty finding it.
Thanks!
-l. -
Hi Laura,
pleae tryformat(today(), "Do").
Best
Frank -
I have a time field in my database. I created with a function of 'TimeField' := now() with hopes it would populate the current time. It does do so, however, it is 3 hours ahead of the actual time. How do I fix this?
-
try this:
---
'TimeField' := time(now())
---
now() includes date and time and you have to tell Ninox exactly what you want to see
Regards
Leo
-
please let me know how to capture the data entry time in noneditable format
-
Hi,
In our soon released new version of Ninox you will have the option "Writable if" not only for tables but as well for data fields. There it is possible to state a condition that will not allow editing on that field it has any content:
Writable if:
MyField = null
Best, Jörg
-
I want to capture the clock time as the entry time and never want that to be edited later. Could you help me?
-
I want to capture the clock time as the entry time and never want that to be edited later. Could you help me?
-
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
-
This thread was very helpful. Finaly found that this information is in the FAQ. Please consider making this either a GLOBAL preference, or a database preference setting. I like my medium date to DISPLAY MMM, DD, YYYY ... but like typing it in via the short format MM/DD/YYYY.. :)
-
This thread was very helpful. Finaly found that this information is in the FAQ. Please consider making this either a GLOBAL preference, or a database preference setting. I like my medium date to DISPLAY MMM, DD, YYYY ... but like typing it in via the short format MM/DD/YYYY.. :)
Content aside
- 6 yrs agoLast active
- 71Replies
- 30131Views