Changing the way date is displayed
Hi, Overall, I love Ninox, but I have spent an entire morning trying to solve what should be a simple problem, including reading dozens of forum posts and the manual. I'm using the desktop Mac version.
I want a date field to display the date like this: 073019, instead of July 30, 2019. Since I use this for my estimate/invoice number, I want it to remain the same and not change daily. I don't understand why there aren't formatting options for the date when creating a field, like there are for time fields. This was extremely easy to do in Filemaker.
I have tried adding this formatting to the date field (Date 2), with no success:
format('Date 2', "MMDDYY")
I have been able to get a formula field to work, but only by using the modifier "today" in the formula. I think that will change daily, correct?
format(today(), "MMDDYY")
Help Please!
4 replies
-
Tim,
The way to go is the formula..
It does take a little bit to retrain your mind.. but once you get the hang of it.. You can crank out some amazing apps rather quickly.
-
Hi Mconneen, thanks so much for the quick response. I had considered that option, and indeed made it work, but that means I need a second "ghost" field, correct?
In your example, you need a "Birthday" field to use for reference, and then a "Formatted Birthday" field to be able to use the formula to show the formatted date. I was trying to avoid having to use 2 fields, seems redundant, and also crowded on my invoice/estimate form page. I realize I don't have to show all fields on that page, but seems a bit pieced together if I'm understanding correctly.
-
Hmm. DISCLAIMER.. I do not do much printing.. :) Do it this way.. Drop the formula idea.. not needed.. It will display on the datda entry form as a usual date type... Within you PDF designer .. Where you see the date.. replace it with the format statement..
-
sorry for the type-o's... I guess I was too excited.. :)
Content aside
- 5 yrs agoLast active
- 4Replies
- 1382Views