Page 1 of 2
Format datetime
Posted: Sat Sep 01, 2018 12:56 pm
by 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
Re: Format datetime
Posted: Sat Sep 01, 2018 7:14 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data which reproduces the issue for analysis
Thank you.
Re: Format datetime
Posted: Mon Sep 03, 2018 8:07 am
by mrapi
hi,see attached report
json data:
Re: Format datetime
Posted: Thu Sep 06, 2018 7:02 am
by 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.
Re: Format datetime
Posted: Thu Sep 06, 2018 7:19 am
by mrapi
k.for the moment seems to work if I select Custom and put format dd/MM/yyyy
thanks
Re: Format datetime
Posted: Thu Sep 06, 2018 7:47 am
by Lech Kulikowski
Hello
Ok.
Please let us know if you need any additional help.
Thank you.
Re: Format datetime
Posted: Fri May 22, 2020 1:22 pm
by 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
Re: Format datetime
Posted: Mon May 25, 2020 8:13 am
by Lech Kulikowski
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
Re: Format datetime
Posted: Mon May 25, 2020 10:53 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue. Please check the last release build.
Thank you.
Re: Format datetime
Posted: Mon May 25, 2020 6:09 pm
by 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