Where do I set the Default Date Format?

BLOMASKY

I am in the US and would like the date to be MM/DD/YY. If I have a html panel with <<bo.datefield>> it shows up as DD/MM/YY. I am sure there is a simple place to change that, but so far, I am not smart enough to find it.

Thanks
Bruce

ACDC

You can find it in "Locale", you may have to create one if it's not being used .. thats assuming the format drop down on the date attribute does not work - but it should

BLOMASKY

Thanks for the answer. I thought you need to set Locale's if you have more than one location. Somewhere the system is formatting the dates in dd-mm-yyyy format. I hoped there would be a simple setting to change that to mm-dd-yyyyy

Bruce

PointsWell

BLOMASKY wrote
Thanks for the answer. I thought you need to set Locale's if you have more than one location. Somewhere the system is formatting the dates in dd-mm-yyyy format. I hoped there would be a simple setting to change that to mm-dd-yyyyy

Bruce

I'd like the default date format to be [Display in local format] rather than MM/DD/YYYY then everyone would be covered.

tford

Not sure where a global setting is, Bruce, but you can also control the formatting right in the HTML:

<<SystemSettings.Dt,'M/d/y'>>

BLOMASKY

tford wrote
Not sure where a global setting is, Bruce, but you can also control the formatting right in the HTML:

<<SystemSettings.Dt,'M/d/y'>>

but, what I cant do is format it when using a CUSTOM Query (which I am starting to like a LOT more. since i can only use the {} to designate the field and cant have the formatting in them.

Bruce

pureist

I'm pretty sure that is not correct ..only being able to use { } to display attribute values in a Custom Query.

I think you can also use Kendo UI Hash Template syntax itself to display attribute values, eg:

#= data["attribute_name"] #

If so, this means the output can be formatted. Perhaps something all together like:

#= kendo.toString(Date(data["attribute_name"]), "d") #
#= kendo.toString(kendo.parseDate(data["attribute_name"]), 'MM/dd/yyyy') #

refer:
http://docs.telerik.com/kendo-ui/framework/templates/overview#hash-literals
http://docs.telerik.com/kendo-ui/framework/globalization/dateformatting

The above is in case the following is wrong because I've misinterpreted your meaning:

You wrote:
"Somewhere the system is formatting the dates in dd-mm-yyyy format"

Don't you set the format in the Attribute settings of the Object? ..which then reflects in Custom Query output?