3 Replies Latest reply: Jun 13, 2016 11:47 AM by Onno van Knotsenburg RSS

    en-US list of SET statements

    Onno van Knotsenburg

      Can someone based in the US or with a PC/laptop set on US do me a simple quick favor and supply me with a copy-paste of the initial 17 SET statements?

       

      In other words:

      Start Sense, open the Data Load editor, and copy-paste those first 17 lines with..

      SET CollationLocale='en-US';

      ?

       

      I got the Dutch and the British version, but need the US version.

       

      Should be one of the easiest questions ever (if you have a US set laptop).

      Thanks ahead!

        • Re: en-US list of SET statements
          Sunny Talwar

          This?

           

          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 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';

          SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

          SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

          SET FirstWeekDay=6;

          SET BrokenWeeks=1;

          SET ReferenceDay=0;

          SET FirstMonthOfYear=1;

          SET CollationLocale='en-US';

            • Re: en-US list of SET statements
              Sunny Talwar

              From sense:

               

              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 TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

              SET FirstWeekDay=6;

              SET BrokenWeeks=1;

              SET ReferenceDay=0;

              SET FirstMonthOfYear=1;

              SET CollationLocale='en-US';

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

              SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

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

              SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';