I have issues with format Datetime

Stimulsoft Ultimate discussion
Post Reply
pdt1704
Posts: 60
Joined: Tue Nov 15, 2011 9:12 pm

I have issues with format Datetime

Post by pdt1704 »

Hi all,
I used version 2019.1.1 and StimulSoft for Web form HTML5
I have 2 column named Expired_Dt is Datetime(null) and ExpiredDt is String, I used SQL command:
SELECT FORMAT('dd/MM/yyyy HH:mm',Expired_Dt) As ExpiredDt, Expired_Dt FROM <Table>...
When export to pdf by report.ExportDocument, I have some issues like that:
- With column named ExpiredDt (type is string), pdf file show current date with format dd/MM/yyyy, not show data in my dataset
- With column named Expired_Dt (type is Datetime(null)), I used function format date with type is "dd/MM/yyyy HH:mm", data show wrong. I used format type "MM.dd.yyyy", data show with format "dd/MM/yyyy"
- Format type is "dd/MM/yyyy HH:mm", but data show not include "HH:mm"
- My report auto refresh although user do nothing

Now, I back to version 2018.1.4, it run OK.

Please help.

Thanks.
Last edited by pdt1704 on Wed Jan 16, 2019 8:48 am, edited 1 time in total.
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: I have issues with format Datetime

Post by Lech Kulikowski »

Hello,

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

Thank you.
pdt1704
Posts: 60
Joined: Tue Nov 15, 2011 9:12 pm

Re: I have issues with format Datetime

Post by pdt1704 »

Hi,
I have sent email to support@stimulsoft.com
Please help.

Thanks.
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: I have issues with format Datetime

Post by Andrew »

Hello,

Thank you very much. I confirm the receipt.
Post Reply