Formatting dates in a text formula
All the date fields in my app are set to display as DD-MMM-YYYY. I have text formulas with that display several dates are they all display in MM-DD-YYYY format. How do I correct this?
Forum Discussion
Use script. I think it is crazy that QuickBase already uses the fantastic date.js library on many of its pages:
https://quickbase.intuitcdn.net/res/70580-2/js/date.js
which provides an amazing number of date manipulation methods as well as a generic date formatting function:
https://github.com/abritinthebay/datejs/wiki/Format-Specifiers
But the formula language has a relatively small set of Date manipulation and formatting options.
So just use script for everything!
https://quickbase.intuitcdn.net/res/70580-2/js/date.js
which provides an amazing number of date manipulation methods as well as a generic date formatting function:
https://github.com/abritinthebay/datejs/wiki/Format-Specifiers
But the formula language has a relatively small set of Date manipulation and formatting options.
So just use script for everything!
So...First link is dead!
If the QB default is set to dd/mm/YYYY (for UK) it seems whenever you use the NOW formula (for instance) it returns the wrong date. So returns 7/9/2017 or 7 Sept when in fact it is 9 July. Can you point me in the right direction?
If the QB default is set to dd/mm/YYYY (for UK) it seems whenever you use the NOW formula (for instance) it returns the wrong date. So returns 7/9/2017 or 7 Sept when in fact it is 9 July. Can you point me in the right direction?