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
-
We already answerded this by mail, but for anyone else:
Breeding_Date + 342
will do the job.
More complicated date calculations can be achieved with
date(Year, Month, Day)
year(Date)
month(Date)
day(Date)
e.g. to get a date of today plus three months:date(year(today()), month(today()) + 3, day(today()))
-
Hi Alexander
In response to KKR1972's query you responded
"Hello,
you can type in dates into the form in the table view. The formatting depends on the system settings. Go to settings and open “Speech and region”. There go to advanced options and go to date. The medium date format is the one how it is displayed in Ninox.
Best regards, Alexander"
I have a similar need to enter a lot of historical data including dates and times. I note that you say that you can type dates into the form in table view. I am using the iPad version and as soon as I tap on the appropriate field in the table, the form appears, and that requires me to scroll through years until I find the year I want. So I don't appear to have any ability to enter the date, but maybe as a new user I am missing something obvious?
Kind regards -
I went to the preferences/date-time on my imac to look at the settings being used for dates. I changed the settings for Medium to mm dd yy. My data coming from the csv file created by excel is in text format as mm/dd/yy. Just testing, I took a look at the TODAY function and got a result of OCT 02, 2016. Was expecting 10/02/16. Any thoughts on this. Is there any function that will take an ASCII string and convert it to a proper date format?
-
Hi:
I have a csv file with a date field (dd/mm/yy). When I import into Ninox, into a date field, it doesn't read it properly. Example:
CSV file date = 8/28/16
Ninox will show the date as "Jan 8, 2028"
There doesn't seem to be any text to date functions in Ninox, so I can't bring it in as a text and then convert to date. I have worked on this for hours and cannot find a solution. I am importing approx. 500,000 records into Ninox, so it would not be feasible to make the changes in Excel prior to import - at least I don't really want to do that. How can I get Ninox to import to a date field correctly from a csv file?
thank you!
joanne -
Oh, sorry!
Here is a sample database:
https://www.dropbox.com/s/gz427ktqi5mip8e/Age.ninox?dl=0
regards
Leo -
Use "Update multiple records..." from the gear menu. Here is the manual page for this task.
Hope this helps
Birger - Ninox Support -
Hi
I want to calculate an appointment field 'appt' based on a date field 'date' in the same record.
- trigger after update on the 'date' field doesnt seem to work with: 'appt'='date'+21 Where 21 are days
- a formula field does the job, but returns a numeric value and it is not an appointment field.
Could anybody give me an hand on this?
Thanks