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
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Now I understand :-)
    I fixed the display in the calendar but you asked about the field view in the record. I'm afraid I can't help you with that. Every Appointment has a time and you can't have the field not show the time.

    Birger - Ninox Support
    • Martin_Sanderson
    • 6 yrs ago
    • Reported - view
    Thanks Leo, that seems to work okay. Thats a great help...

    There appears an error, in the
    Trigger After Update (D := ((number(F)+"/")+number((G-F)))

    Invalid formula: Error: Field not found: "D" a line 1, column 5

    should I ignore this?
    • kustra
    • 6 yrs ago
    • Reported - view
    Hello,

    I'm currently on a 30-day trial for the cloud service. It looks like Ninox can provide a lot of the functionality I'm looking for for my business. I want to use the multi-line text field to enter notes/contact history for a contact/company, but it would be great if there were a way for the current date to be entered automatically at the beginning of an entry so that I know when I wrote it, or when I sent an email to the contact. Is this possible?
    Regards,
    Dean
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Here is a small example how this could be done. Enjoy:


    Birger - Ninox Support
    • kustra
    • 6 yrs ago
    • Reported - view
    Dear Birger,
    Many thanks for your very speedy reply - I'll take a look about incorporating this function into my trial database.
    Thanks again.
    D.
    • michaeltoc
    • 6 yrs ago
    • Reported - view
    The function weekday(date) is supposed to return 0=Sunday, but for me it its returning 0=Monday. (System preferences is set to Sunday as the first day pf the week).
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Ninox has not native preferred first day of the week. It will look at the browser and/or system preferences to determine the first day of the week.

    Birger - Ninox Support
    • jenireid28
    • 6 yrs ago
    • Reported - view
    Hi, I have a choice field called "Callback in" with the options 3, 6, 9 and 12 (being a number of months).

    I want to calculate a date which is x number of months from a certain date ("Last contacted"), where x is the choice selected.

    I tried "'Last contacted' +( 30 * number('Callback in'))" as the simplest solution but it doesn't work - it just adds 1, 2, 3 or 4 months to the date, not 3, 6, 9 or 12.

    Can you help please? Alternatively is there a way of calculating it using calendar months rather than an average of 30 days per month?

    Thank you!
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    Hello Jeni,
    either

    'Last contacted' + (30 * number (text ('Callback in'))

    or with calendar months

    date (year ('Last contacted'), month ('Last contacted') + number (text ('Callback in')), day ('Last contacted'))

    Leo
    • jenireid28
    • 6 yrs ago
    • Reported - view
    Thank you - that's working now, I knew it would be something simple.

    However, it only works once and then the fields "lock" unless I come out of the record and go back in. Is that correct? I was hoping I could select the different options without going in and out of the record?

    Thanks
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    I don't understand that. Which data fields do you mean?
    • jenireid28
    • 6 yrs ago
    • Reported - view
    Hi Leo - now I have put the formula in place, I can't select anything from "Callback in" unless I reload the database. I can then select an option and it updates the date.

    However, if I then try to change "Callback in" to a different choice, it won't let me. I have to reload the database, go back to the record and then it works.

    Does that make sense?
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    I do not understand. If you have three fields:

    1. 'last contacted' (date)
    2. 'callback in' (choice)
    3. 'Next Contact' (f (x) with your formula)

    Then everything should work.
    • jenireid28
    • 6 yrs ago
    • Reported - view
    Hi Leo - can I send you the database so you can see what I mean?
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    • stefo
    • 6 yrs ago
    • Reported - view
    Hello!
    is possible to show date without year?
    eg.
    07 mar
    thanks and regards.
    stefo
    • Birger_H
    • 6 yrs ago
    • Reported - view
    That would be:
    –––
    format( 'Date field', "dd mmm" )
    –––


    Birger - Ninox Support
    • Thierry
    • 6 yrs ago
    • Reported - view
    Hi, I'm a current Tapforms user investigating wether Ninox could be a useful replacement...
    I need a calculated field to show the remaining years & months between "today" and a date in the future (other field).
    I can't find in your user manual wether Ninox can actually provide such a type of format as the result of a calculation? Like for example: "4 years, 3 months".
    Would that be possible and how should that be achieved?
    Much appreciated.
    Thierry
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    Hi Thierry,
    Here is a sample database. The duration is calculated in both directions (future and past)

    https://www.dropbox.com/s/1fz6tdefgk0pjkn/DURATION.ninox?dl=0

    regards
    Leo
    • Thierry
    • 6 yrs ago
    • Reported - view
    Hi,
    i have a "date X" field and need to calculate (in a new field) dateX minus 120 days, (with the format of the result to be also a date of course).
    Could you please provide me the correct formula for this as i'm struggling...
    Much appreciated,
    Thierry
    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view
    Hi Thierry,

    you can use a formal field:

    dateX - 120

    it will give out a date, as well.

    Best regards, Alex
    • Andrea
    • 6 yrs ago
    • Reported - view
    Hi,

    can I change the name of a field in bold and the size of the font?
    Thx
    • Birger_H
    • 6 yrs ago
    • Reported - view
    No. Not yet. You can set the global font size here:

    Birger - Ninox Support
    • Andrea
    • 6 yrs ago
    • Reported - view
    Hi,

    I've the function in a function field named "Check":

    if 'Fattura N.' != null then
    "Fatturato"
    else
    if 'Data ricezione' != null and 'Data invio a fornitore' != null and 'Data evasione fornitore' != null and 'Data invio a cliente' != null then
    "Fatturabile"
    else
    "Non Fatturabile"
    end
    end

    I would like to add an icon near text "Fatturato", "Fatturabile", "Non Fatturabile".
    Is it possible?
    thx a lot

Content aside

  • 5 yrs agoLast active
  • 71Replies
  • 29890Views