Format datetime

[mrapi]

Hi.i'm trying to format datetime field to dd/MM/yyyy but doesn't seems to work

is shown as MM/dd/yyyy


thanks

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis

Thank you.

[mrapi]

hi,see attached report
json data:

Code: Select all

  {'DATA': '2018-09-15T00:00:00'}

[Lech Kulikowski]

Hello,

We have found some problems with format DateTime with time values.
Please try to remove time from your value. Also, we have added this task to our to-do list.

Thank you.

[mrapi]

k.for the moment seems to work if I select Custom and put format dd/MM/yyyy
thanks

[Lech Kulikowski]

Hello

Ok.
Please let us know if you need any additional help.

Thank you.

[mrapi]

Hi
it that fixed?
in version 2020.2.2 it doesn't work with custom format dd/MM/yyyy, now it looks like that:


tried date format:





but looks like that:



I need a simple dd/MM/yyyy format

thanks

[Lech Kulikowski]

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue. Please check the last release build.

Thank you.

[mrapi]

Hi,i can't test with the latest version because of this issue(fixed on your side) viewtopic.php?f=27&t=58764
I've sent you some data to test

I found a little fix,instead of format I use ToString:

Code: Select all

{tbfc.DATA_FACT.ToString("dd/MM/yyyy")}

but instead of 05/11/2019 is shonw as 5/11/2019

thanks