DATE_FORMAT in Ticker?

Get Help
1

In a dataset I have a string field that holds a date like ‘2016-07-01 21:15’, but I would like to show it as a full date in words in the apperance without converting/changing the orginal value. Can I do this somehow?

I found something like DATE_FORMAT, but I don’t know how and if it wil work.
(I works when I make it a formula in the dataset, but I need the date formatted in several parts elsewhere, once the day only, once only the time, etc.)

I hope you understand what I try to accomplish :slight_smile:

Kind regards,
Eric

2

mm I think that you would need to have separate formula column for this (different formulas for different output).

So lets say your column with date is called 'Date’
and in this column you have a following value:
2016-07-04 14:55:00

then you can have a formula column called ‘Formula’ with this in formula field (as an example):
DATE_FORMAT(Date,'%b %d %Y %h:%i %p')

Then in ticker appearance tab you would double click the ‘Formula’ to show it on the layout and it will take the date from your Date column and ‘convert’ it and display this on the layout: (in this example:)
Jul 04 2016 02:55 PM

http://www.w3schools.com/sql/func_date_format.asp

3

Hi Peter,

Thank you for your reply and that works fine, but now I have a final question:

No matter what I try, the transformed date into words keeps translated in English in stead of any other language.
Is there some dependency I seem to forget??

So in short can I translate the result of DATE_FORMAT(dtEventStart, ‘%W %d %M %Y’) into French, Dutch, etc.?

Kind regards,
Eric

4

I think that you would need to change lc_time_names in your mysql settings.

Have a look here how to do it https://dev.mysql.com/doc/refman/5.5/en/locale-support.html

It’s pretty much one command to change it, so you can give it a try and let me know if it works.

Also I’m not entirely sure if there will be any side effects of that change, but if there will be it’s easy to change it back to default value.

5

Hi Peter,

You rock!! I changed the setting and now the dates are translated correctly. Thanks again!

Kind regards,
Eric