Format datetime
Format datetime
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
is shown as MM/dd/yyyy
thanks
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format datetime
Hello,
Please send us a sample report with test data which reproduces the issue for analysis
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis
Thank you.
Re: Format datetime
hi,see attached report
json data:
json data:
Code: Select all
{'DATA': '2018-09-15T00:00:00'}
- Attachments
-
- Report.mrt
- (4.4 KiB) Downloaded 222 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format datetime
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.
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
k.for the moment seems to work if I select Custom and put format dd/MM/yyyy
thanks
thanks
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format datetime
Hello
Ok.
Please let us know if you need any additional help.
Thank you.
Ok.
Please let us know if you need any additional help.
Thank you.
Re: Format datetime
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
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
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format datetime
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format datetime
Hello,
We couldn't reproduce the issue. Please check the last release build.
Thank you.
We couldn't reproduce the issue. Please check the last release build.
Thank you.
- Attachments
-
- Annotation 2020-05-25 125220.png (51.52 KiB) Viewed 4434 times
Re: Format datetime
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:
but instead of 05/11/2019 is shonw as 5/11/2019
thanks
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")}
thanks