Format datetime

Stimulsoft Reports.JS discussion
mrapi
Posts: 277
Joined: Sat Dec 20, 2008 1:08 am

Format datetime

Post by mrapi »

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

thanks
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski »

Hello,

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

Thank you.
mrapi
Posts: 277
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post by mrapi »

hi,see attached report
json data:

Code: Select all

  {'DATA': '2018-09-15T00:00:00'}
Attachments
Report.mrt
(4.4 KiB) Downloaded 218 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post 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.
mrapi
Posts: 277
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post by mrapi »

k.for the moment seems to work if I select Custom and put format dd/MM/yyyy
thanks
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski »

Hello

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

Thank you.
mrapi
Posts: 277
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post 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:
Image

tried date format:

Image



but looks like that:

Image

I need a simple dd/MM/yyyy format

thanks
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski »

Hello,

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

Thank you.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski »

Hello,

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

Thank you.
Attachments
Annotation 2020-05-25 125220.png
Annotation 2020-05-25 125220.png (51.52 KiB) Viewed 4363 times
mrapi
Posts: 277
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post 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
Post Reply