0 votes

In the Netherlands we use hyphens in our dateformat (e.g. 14-01-2019)
For our cloud customers on Efficy 10SP2 and Efficy 11 we get an error when we want to use specific dates in the criteria of Custom Views or Queries.

Only when we don't use the datepicker and manually fill in the date with slashes (and save it directly... not apply!!) it's used, but every time we change this Custom View or Query we have to re-fill this date again :-(

Anyone has any idea which part is the cause of this problem?
- The server configuration ?
- The settings in custom.js ?
- The regional settings of the client ?
- An error in Efficy itself ?

In this document you will find an example with screenshots.

Important to mention that on all other parts of Efficy we don't have a problem with filling in or showing dates

asked in Errors by (158 points)
Jan, do you have a non-PRD environment where we can simulate it. Your document is production, but I cannot logon and have a look at the Efficy server settings.
Kristof,
An example of a test environment with this issue is the current test environment of Socia:
https://submariners.efficy.com/crm//view/Comp/2400038233

1 Answer

+1 vote

Jan,

I tested some obvious settings:

Client side, I do see the following in Custom.js

DateSeparator = '-',

Serverside, using the SOAP request below, you can return the systemsettings

Request

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope" xmlns:efficy="http://www.efficy.com">
    <SOAP-ENV:Body>
        <efficy:api>
            <datacontainer operation="systemsettings"/>
        </efficy:api>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Response

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope" xmlns:efficy="http://www.efficy.com">
    <SOAP-ENV:Body>
        <efficy:api page="" _macrofile="" handled="true">
            <datacontainer operation="systemsettings" handled="true">
                <document class="StringList">
                    <rows>
                        <row>ThousandSeparator=.</row>
                        <row>DecimalSeparator=,</row>
                        <row>DateSeparator=-</row>
                        <row>ShortDateFormat=dd-mm-yyyy</row>
                        <row>LongDateFormat=dddd d mmmm yyyy</row>
                        <row>TimeSeparator=:</row>
                        <row>ShortTimeFormat=hh:mm</row>
                        <row>LongTimeFormat=hh:mm</row>
                        <row>TwoDigitYearCenturyWindow=50</row>
                        <row>FileBase=efficy/</row>
                        <row>Language=EN</row>
                        <row>SessionHandle=3FE83CE4-0A130276</row>
                        <row>Version=DSoft_4.0</row>
                        <row>ServerVersion=EfficyServer.dll 11.1.14832.0 2018-10-16 10:01</row>
                        <row>ClientVersion=efficy.dll 11.1.14832.0 2018-10-16 10:01</row>
                    </rows>
                </document>
            </datacontainer>
        </efficy:api>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

So, the server side part also matches the client side configuration.
Check if these are both matching in TEST and PRODUCTION.

answered by (7.4k points)
edited by
Welcome to Efficy Overflow, where you can ask questions and receive answers from other members of the community.
1,249 questions
1,519 answers
1,859 comments
328 users