Format datetime

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

Format datetime

Post by mrapi » Sat Sep 01, 2018 12:56 pm

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: 2455
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski » Sat Sep 01, 2018 7:14 pm

Hello,

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

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

Re: Format datetime

Post by mrapi » Mon Sep 03, 2018 8:07 am

hi,see attached report
json data:

Code: Select all

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

Re: Format datetime

Post by Lech Kulikowski » Thu Sep 06, 2018 7:02 am

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: 220
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post by mrapi » Thu Sep 06, 2018 7:19 am

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

Re: Format datetime

Post by Lech Kulikowski » Thu Sep 06, 2018 7:47 am

Hello

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

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

Re: Format datetime

Post by mrapi » Fri May 22, 2020 1:22 pm

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: 2455
Joined: Tue Mar 20, 2018 5:34 am

Re: Format datetime

Post by Lech Kulikowski » Mon May 25, 2020 8:13 am

Hello,

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

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

Re: Format datetime

Post by Lech Kulikowski » Mon May 25, 2020 10:53 am

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 75 times
mrapi
Posts: 220
Joined: Sat Dec 20, 2008 1:08 am

Re: Format datetime

Post by mrapi » Mon May 25, 2020 6:09 pm

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