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)

71 replies

null
        • Andrea
        • 6 yrs agoWed, February 14, 2018 at 6:35 AM UTC
        • Reported - view
        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
        • Leonid_Semik
        • 6 yrs agoWed, February 14, 2018 at 9:08 AM UTC
        • Reported - view
        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
        • Leonid_Semik
        • 6 yrs agoWed, February 14, 2018 at 9:28 AM UTC
        • Reported - view
        • Andrea
        • 6 yrs agoThu, February 15, 2018 at 8:57 PM UTC
        • Reported - view
        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
        • Alexander_Koenig
        • 6 yrs agoFri, February 16, 2018 at 2:47 PM UTC
        • Reported - view
        Hi Andrea,

        we have this feature planned.

        Best regards, Alex
        • Andrea
        • 6 yrs agoWed, February 28, 2018 at 1:36 PM UTC
        • Reported - view
        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.
        • Frank_Bohmer
        • 6 yrs agoWed, February 28, 2018 at 4:24 PM UTC
        • Reported - view
        Hi Andrea, thanks for reporting this. Is it on a Windows PC?
        Best, Frank
        • Andrea
        • 6 yrs agoWed, February 28, 2018 at 5:51 PM UTC
        • Reported - view
        Yes the problem si on Windows PC. Instead using Firefox on mac it works well.
        • Yuri
        • 6 yrs agoMon, March 5, 2018 at 5:28 PM UTC
        • Reported - view
        there is a list of the name of icons?
        • Birger_H
        • 6 yrs agoTue, March 6, 2018 at 7:18 AM UTC
        • Reported - view
        • Laura
        • 6 yrs agoTue, March 6, 2018 at 4:46 PM UTC
        • Reported - view
        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.
        • Frank_Bohmer
        • 6 yrs agoWed, March 7, 2018 at 8:47 AM UTC
        • Reported - view
        Hi Laura,

        pleae try format(today(), "Do").

        Best
        Frank
        • SMoore
        • 6 yrs agoSun, April 29, 2018 at 4:14 PM UTC
        • Reported - view

        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?

        • Leonid_Semik
        • 6 yrs agoSun, April 29, 2018 at 4:31 PM UTC
        • Reported - view

        try this:

        ---

        'TimeField' := time(now())

        ---

        now() includes date and time and you have to tell Ninox exactly what you want to see

         

        Regards

        Leo

        • jayarajmb2004_gmailcom
        • 6 yrs agoSun, July 8, 2018 at 5:57 PM UTC
        • Reported - view

        please let me know how to capture the data entry time in noneditable format

        • Support
        • 6 yrs agoWed, July 18, 2018 at 11:49 AM UTC
        • Reported - view

        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

        • jayarajmb2004_gmailcom
        • 6 yrs agoTue, July 31, 2018 at 3:36 PM UTC
        • Reported - view

        I want to capture  the clock time as the entry time and never want that to be edited later. Could you help me?

        • jayarajmb2004_gmailcom
        • 6 yrs agoTue, July 31, 2018 at 3:36 PM UTC
        • Reported - view

        I want to capture  the clock time as the entry time and never want that to be edited later. Could you help me?

        • Sakshi_Singh
        • 6 yrs agoTue, July 31, 2018 at 3:53 PM UTC
        • Reported - view

        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

        • Mconneen
        • 6 yrs agoThu, August 2, 2018 at 6:26 PM UTC
        • Reported - view

        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.. :) 

        • Mconneen
        • 6 yrs agoThu, August 2, 2018 at 6:26 PM UTC
        • Reported - view

        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.. :)