DateTime Format Issue

Stimulsoft Reports.JS discussion
Post Reply
BCS
Posts: 83
Joined: Thu Nov 17, 2016 5:47 am

DateTime Format Issue

Post by BCS »

I need to format datetimes as follows

MM/dd/YYYY hh:mm:ss tt

input:
{
"PunchOutTime" : "2016-11-15 22:44:30"
}

Expected: 11/15/2016 10:44:30 PM

...instead it shows

11/15/2016 10 PM:44:30 PM

In the datasources its set to datetime, for text format on the control its set to custom: "MM/dd/YYYY hh:mm:ss tt"

I'd like to purchase this suite but this is something I really need in many projects is date time formatting.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: DateTime Format Issue

Post by HighAley »

Hello.

We have reproduced the issue.
We need some time to fix it.
We will let you know about results.

Thank you.

Ticket reference: #3464
BCS
Posts: 83
Joined: Thu Nov 17, 2016 5:47 am

Re: DateTime Format Issue

Post by BCS »

Forgot to mention its in the external designer as well if you use a .json file with some data in it, in the preview mode.

Is it also by design that the external designer offsets all datetimes with the system UTC setting? My times were off by 6 hours due to -6000 or CST (Central Standard Time USA)

EDIT: also this is the Mac version of the external designer.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: DateTime Format Issue

Post by HighAley »

Hello.

The time should be in current time zone.
We need to check the Mac designer.

Thank you.

Ticket reference: #3485
BCS
Posts: 83
Joined: Thu Nov 17, 2016 5:47 am

Re: DateTime Format Issue

Post by BCS »

Silly question but how can I check the status and progress of those ticket references or is that a memo for yourself or other support staff?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: DateTime Format Issue

Post by HighAley »

Hello.

This is a ticket of our internal system.
It helps us to find it faster.

Also you could write you questions to support@stimulsoft.com. Based on such questions a ticket on the https://stimulsoft.zendesk.com/ ticket system will be created.
You could see the status of the ticket there.

Thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: DateTime Format Issue

Post by HighAley »

Hello.

We have made an improvement.
Please, check our next prerelease build that will be available on Friday.

Thank you.
BCS
Posts: 83
Joined: Thu Nov 17, 2016 5:47 am

Re: DateTime Format Issue

Post by BCS »

Okay, thank you for looking into this issue.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: DateTime Format Issue

Post by Alex K. »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
BCS
Posts: 83
Joined: Thu Nov 17, 2016 5:47 am

Re: DateTime Format Issue

Post by BCS »

As of version 2016.12.02, the zip archive and the Mac OS Designer

The problem is still persisting as shown in screenshots, I am sending my datetimes in JSON like so:

...
"EditedTimeIn" : "2016-11-15 15:44:30",
"EditedTimeOut" : "2016-11-15 23:00:30",
...

Image
Image
Image
Post Reply