Formatting Date
How do I format the date to show the weekday, month, day, year? For example, I would like the date column to show "Wed, 06/06/2018".
8 replies
-
Use a formula field to get a custom format of a date field like this:
–––
format('Date field', "ddd, DD/MM/YYYY")
–––Birger
-
Can you show me exactly how to do this?
-
PLease have a look at the function and language reference, here are more examples.
Or join one of our webinars:
https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg
Best, Alex
-
Memo to "No Name Support" -
Your answer above is a very bad answer to a very simple question. (If you worked for me, you'd be fired today.)
I will explain to you in simple words:
Webinars are mostly a waste of time. Most forums are a waste of time. Because, they are long ways to go a short distance.
What database admins need is quick, efficient, focused ways to get answers quickly. Without waiting for a webinar. Without waiting for "support" on a forum. Without digging through pages of manuals. Why doesn't the boss of support at Ninox understand that? (I would fire him, too, because support is the weakest part of the NX package. His sloppy management is wasting time and money on both sides of the table.)
Some of the NX staff here are intelligent and helpful, but not all. But the design of the software for the forum is awful. There is today such good software available for forums, why is it not used here?
-
Hello Ron,
please check the function and language referrence. This is the best condensed source to get information about how to use Ninox. Webinars are also a great way to get in touch with Ninox staff and collaborate with other users.
About your issue:
You need to edit how the date is displayed in the column. Click on the column head and pick the f(x) sign to enter the formula editor.
Here you will apply the format() function which was already posted before:
format('Date field', "ddd, DD/MM/YYYY")
Let me know if we can help. You have plenty of possibilities to interact with support. Please see our help page.
Best regards, Alex
-
Hi,
I have a similar question but it is about dates displaying in the forms. How do I change the dafault dte fomat within a form or, preferably, across the whole database?
-
Hi,
As you are Ninox cloud user, please note that Ninox picks the date format from the browser properties. To change the date format across Ninox, please change the same in your browser settings.
Regards,
Sakshi-Ninox -
Hi,
As you are Ninox cloud user: if you use Ninox from web, then please note that Ninox picks the date format from the browser properties. To change the date format across Ninox, please change the same in your browser settings.
Regards,
Sakshi-Ninox
Content aside
- 6 yrs agoLast active
- 8Replies
- 4677Views