0

Problems with Date/Time field

The below code isn't working in the web version:

---

let d := date('Date / Time');
select Table where date('Date / Time') = d

---

Works fine in the Mac app.

6 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Nick, 

    Where in Ninox are you are using that formula?

    (select is not supported in the "Update multiple records" function in the browser version)

    Kind regards, Jörg

    • Nick
    • 5 yrs ago
    • Reported - view

    Hi Jorg,

    In a table of daily activities I have a View to display all similar (by date) records e.g. 3 records today etc.

    • Nick
    • 5 yrs ago
    • Reported - view

    also, Works fine with a Date field but not with Date / Time field.

    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Nick, 

    My tests worked well also in the browser.

    Could we please have a look on it together? 

    In order to do so you are invited to make an appointment for a zoom call with me via the following link: 

    https://calendly.com/ninoxteam 

    Thank you very much.

    Best, Jörg

    • Nick
    • 5 yrs ago
    • Reported - view

    Hmmm!

    It's possible to be a date format problem?

    In the machine (and of course same system) I have different date formats between versions (this is really a headache!!!).

     

    Screenshot 2019-10-18 at 7.40.26 PM

    also, Ι see different results in table reports between the two versions.

    Best, Nick

    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Nick, 

    please check if you have set different date (language) formats in your device and your browser settings. 

    The Ninox App takes the format settings from your device settings and the Ninox browser version takes it from the browser settings.

    Best, Jörg

Content aside

  • 5 yrs agoLast active
  • 6Replies
  • 1748Views