A
Alex Hart
Guest
Could we get a change in date formatting in 11.4? Or should I post this somewhere else? Currently I can do STRING(TIME,"HH:MM AM") but for dates I must use numbers STRING(DATE,"99/99/99") . But it would be so much more useful if we could also do something similar for dates. Some examples of what I would like: STRING(DATE, "dd/mm/ccyy") -- 24/02/2014 STRING(DATE, "mmm dd, yyyy") -- Feb 24, 2014 STRING(DATE, "dd-month-yy") -- 24-February-14 STRING(DATE,"yyddd") -- 14055 ...... Currently we have to write our own function/class to do these conversions.
Continue reading...
Continue reading...