Easy Fix for DateTime Compatibility

[Cam: @muunkky]

Hi,

My regional settings cause a problem with the datetime format used as
the default by Rise. (dd/MM/yyyy).

This is an absolute show-stopper that requires me to manually edit the
generated code.

If you could kindly change the default to the ISO Standard format for
sending the datetime data to SQL Server, which is "YYYYMMDD" (no
separators). Using the ISO format is more "international," and is
independent of the default language.

Thanks in advance.

Cameron

[Cam: @muunkky]

Current workaround:

Add 'SET DATEFORMAT "dmy"' to start of script.

[HOlsen]

I am guessing that you refer to dates stored in the model via the data
manager. Dates entered into the datamanager are actually stored in the
model in ISO 9601 format. When dates are presented to a user in the
data manager, it is presented according to the regional settings of
the client computer. However, as you pointed out, when generating a
database script the date is also generated according to the regional
settings of the client computer. We will update the code generators so
that they generate dates in an ISO format accepted by the databases.

Best regards,
RISE to Bloome Software

> > Cameron- Hide quoted text -
>
> - Show quoted text -