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 ago
    • 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 ago
    • 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 ago
    • Reported - view
    • Andrea
    • 6 yrs ago
    • 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 ago
    • Reported - view
    Hi Andrea,

    we have this feature planned.

    Best regards, Alex
    • Andrea
    • 6 yrs ago
    • 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 ago
    • Reported - view
    Hi Andrea, thanks for reporting this. Is it on a Windows PC?
    Best, Frank
    • Andrea
    • 6 yrs ago
    • Reported - view
    Yes the problem si on Windows PC. Instead using Firefox on mac it works well.
    • Yuri
    • 6 yrs ago
    • Reported - view
    there is a list of the name of icons?
    • Birger_H
    • 6 yrs ago
    • Reported - view
    • Laura
    • 6 yrs ago
    • 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 ago
    • Reported - view
    Hi Laura,

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

    Best
    Frank
    • SMoore
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • Reported - view

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

    • Support
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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
    • 5 yrs ago
    • 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.. :) 

Content aside

  • 5 yrs agoLast active
  • 71Replies
  • 29890Views