5 Replies Latest reply: Jan 8, 2015 12:19 PM by Rob Wunderlich RSS

    create two different SET DateFormat ?

    Steve Lord

      Hi, I want to make a date format for MMM-YYYY (Jan-2015) for use in some listboxes and still keep the other M/D/YYYY date format for use in field values.  Can someone provide me the line to add below for MMM-YYYY date format that wouldn't replace or conflict with the default date format?  Previously, I'd been doing weird concatenate month() year() functions in script and would like to quit that.


      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='$#,##0.00;($#,##0.00)';

      SET TimeFormat='h:mm:ss TT';

      SET DateFormat='M/D/YYYY';

      SET ____________='MMM-YYYY', //what goes in this blank?

      SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';