A
Alex Hart
Guest
Currently I can do STRING(TIME,"HH:MM AM") but for dates I must use numbers STRING(DATE,"99/99/99") . It would be so much more useful if we could also do something similar for dates, allow the same functionality available in most modern languages for manipulating dates for display. 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-MMM-yy") -- 24-February-14 STRING(DATE, "julian") -- 14055 and also allowing us to get the day of week (full or abbreviated) Examples of JAVA formatting - http://www.tutorialspoint.com/java/java_date_time.htm
Continue reading...
Continue reading...
