0

Date Field Question.

Is there a fast way to enter a date? The best I have found so far is jan12001. I would like it if I could enter it like 1/1/01.

Also, can the date format be changed to show as 1.1.01 instead of this?

Screen Shot 2019-07-15 at 8.45.38 AM

14 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Mr. K... The date data type uses the system configured date format.  So.. from an "input" perspective..  US dates are looking for Month Day Year. ..   From an OUTPUT perspective.. You can always format the date anyway you want. 

     

    Hope this helps. 

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Please explain the way to format the output. 

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Mr. K,

    Please have a look here https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language in the section date functions for more explanation.

    • Ivan_Savochenko
    • 4 yrs ago
    • Reported - view

    Play with this function, change tokens in double quotes with those from tokens table (see link from previous message):

     

    format(now(), "dddd, Do of MMMM YYYY, h:mm a")

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Where do I enter the formula?

    Screen Shot 2019-07-15 at 5.06.46 PM

    • Mr_K
    • 4 yrs ago
    • Reported - view

    It appears it goes in the Show As box. If so, please give me a formula to enter there that makes my Date Paint Applied field format as 1.1.07. I'm new to this, so seeing it work helps me understand how to do it. Thanks.

    • Cegep de jonquiere
    • James_Deraps.1
    • 4 yrs ago
    • Reported - view

    No Show as is for the calendar. To write something in the calendar.

    • Ivan_Savochenko
    • 4 yrs ago
    • Reported - view

    Date field in a record input form shows dates in format based on your OS locale preferences. You can't change it with current Ninox prefs.

    "Show As" field from your screenshot does form what you will see in Ninox calendar on that date. It's not even about date at all.

    What you can do then? You can format the way your tables/reports will show up given dates. So open column formula editor:

    Screenshot 2019-07-16 at 13.39.23

    And replace 'Date Paint Applied' with format('Date Paint Applied', "M.D.YYYY").

    • Mr_K
    • 4 yrs ago
    • Reported - view

    So is there a way to do what I asked in the first place. Format the output in the Date Applied field to read as 1.1.07?

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I had not refreshed my page to see Ivan Savochenko reply. Thanks for that answer Ivan. Now I get it. I'm testing that now.

    • Mr_K
    • 4 yrs ago
    • Reported - view

    'Date Paint Applied', "M.D.YYYY" returns an error:

    Screen Shot 2019-07-16 at 6.48.19 AM

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Got it now. I needed to add all of the formula "format('Date Paint Applied', "M.D.YYYY")."

    Now, is there a way to center that text in the column?

    Screen Shot 2019-07-16 at 7.04.25 AM

    • Ivan_Savochenko
    • 4 yrs ago
    • Reported - view

    Nope.

    Numbers align right, dates align center, text strings align left. Function format() turns numeric data into text strings.

    • Sarah.1
    • 2 yrs ago
    • Reported - view

    This may no longer matter, but if you want the date to align center,  as a date format, without it becoming a string, you have to change the settings on your computer to display the date as 01/01/2021. On my mac, I had to go into language and region preferences > advanced > dates and change the "medium date" format to 01/01/2021 for the date change to be reflected in Ninox. I think this is important because the string format would not sort in correct (chronological) ascending/descending order, it has to be a date to do this correctly. This took me forever to figure it out, so hopefully this helps someone with date formatting!

Content aside

  • 2 yrs agoLast active
  • 14Replies
  • 3417Views