Date format in dbr

jpaulo · December 13, 2018, 1:40am

Hi,

I’m building an HTML from scratch but the Date fields are not formatting the date strings as expected:

I took the format example from this forum topic: Date picker not updating cube - #2 by plim

Am I referencing the date-option correctly?

Thanks!

Joao

plim · December 13, 2018, 2:09am

Hi @jpaulo,

That looks alright. Was it consistently doing the mm/dd/yyyy format if you pick other dates? How about the Browser Cache? Have you tried to clear that?

Can you double check on the DOM that the HTML rendered already has that option passed in? If you right click on that element on Chrome, and select “Inspect Element”, can you help verify that you can see this:

If not, then clearing the cache should help resolve that.

Otherwise, try to put it out of that patternfly directive(?) and check if it is still the same.

–
Paul

jpaulo · December 13, 2018, 4:21am

Hi Paul,

Thanks for the response.

Yes. Inspecting shows tm1-date-option="{format:‘dd/MMM/yyyy’}" or any other content that I fill in. Regardless, the filed keeps showing the default format.

Joao

plim · December 13, 2018, 4:57am

Hi @jpaulo,

The default format is actually yyyy-mm-dd. There could be some possible hook happening. Can you try it out on a pure Canvas page?

Have tried it out with both (the first one I did not pass anything which would now retrieve the default in Canvas):

<tm1-ui-dbr tm1-instance="dev" tm1-cube="System Info" tm1-elements="Budget Year,Comment" tm1-date-option="{}"></tm1-ui-dbr>

<tm1-ui-dbr tm1-instance="dev" tm1-cube="System Info" tm1-elements="Server Time,Comment" tm1-date-option="{format:'mm-yyyy'}"></tm1-ui-dbr>

And both looks alright:

What version of Canvas are you in?

–
Paul

jpaulo · December 14, 2018, 1:27am

Hi @plim

I’m in fact using Apliqo-UX. Applying the empty option “{}” , I get the format mm/dd/yyyy.

For now, what we’re doing is merge, in an HTML form, the tm1-ui-dbr form numbers and common text fields and uib-datepicker for dates. Then we pass the dates as parameters to a process.

Thanks for the help.

Cheers,

Joao