bug with DateTime formatter
Posted: Thu Apr 21, 2011 2:51 pm
Hello,
Please tell us how you connect the data to the report?
Thank you.
Creating reports and dashboards | Stimulsoft community forum
Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/
bug with DateTime formatter
Page 1 of 2
bug with DateTime formatter
Posted: Fri Apr 22, 2011 1:43 am
bug with DateTime formatter
Posted: Mon Apr 25, 2011 2:14 pm
bug with DateTime formatter
Posted: Tue Apr 26, 2011 2:02 am
Hello,
We understand the problem, will try to to solve it as quickly as possible. We will report on the forum about the solutions to this problem.
Thank you.
We understand the problem, will try to to solve it as quickly as possible. We will report on the forum about the solutions to this problem.
Thank you.
bug with DateTime formatter
Posted: Fri May 06, 2011 11:06 am
From the May 04 release, I see :
But I'm afraid that its still not working for me, neither Dates, nor Times.
Additionally, I'm trying some Expressions with my DateTime field, such as...
Neither of these ideas are working out for me either. All I get is blank boxes.
By the way, is there a place I can see any errors that were generated? Whats the best way to debug reports?
Thanks!
Code: Select all
Fix: Improved work with DateTime formatting.
Fix: An error when selecting a data column for charts, filters, sorting, if a relation is used.Additionally, I'm trying some Expressions with my DateTime field, such as...
Code: Select all
{Year(QDeposit.OrderDate)}-{Month(QDeposit.OrderDate)}-{Day(QDeposit.OrderDate)}Code: Select all
{DateToStr(QDeposit.OrderDate)}By the way, is there a place I can see any errors that were generated? Whats the best way to debug reports?
Thanks!
bug with DateTime formatter
Posted: Tue May 10, 2011 5:02 am
Hello,
For convert a date to a string value, you can use the following expressions:
There are following custom format specifiers:
y (year)
M (month)
d (day)
h (hour 12)
H (hour 24)
m (minute)
s (second)
f (second fraction)
F (second fraction, trailing zeroes are trimmed)
t (PM or AM)
z (time zone)
Examples:
Thank you.
For convert a date to a string value, you can use the following expressions:
Code: Select all
{QDeposit.OrderDate.ToString("yyyy-MM-dd")}
2008-03-09
{Format("{0:yyyy-MM-dd}", QDeposit.OrderDate)}
2008-03-09y (year)
M (month)
d (day)
h (hour 12)
H (hour 24)
m (minute)
s (second)
f (second fraction)
F (second fraction, trailing zeroes are trimmed)
t (PM or AM)
z (time zone)
Examples:
Code: Select all
{QDeposit.OrderDate.ToString("y yy yyy yyyy")}
8 08 008 2008
{QDeposit.OrderDate.ToString("M MM MMM MMMM")}
3 03 Mar March
{QDeposit.OrderDate.ToString("d dd ddd dddd")}
9 09 Sun Sunday
{QDeposit.OrderDate.ToString("h hh H HH")}
4 04 16 16
{QDeposit.OrderDate.ToString("m mm")}
5 05
{QDeposit.OrderDate.ToString("s ss")}
7 07
{QDeposit.OrderDate.ToString("f ff fff ffff")}
1 12 123 1230
{QDeposit.OrderDate.ToString("F FF FFF FFFF")}
1 12 123 123
{QDeposit.OrderDate.ToString("t tt")}
P PM
{QDeposit.OrderDate.ToString("z zz zzz")}
+2 +02 +02:00Thank you.
bug with DateTime formatter
Posted: Tue May 10, 2011 7:59 am
Sadly, that still isn't working for me...
Field Properties
Header Definition
Actual Rendering
Field Properties
Header Definition
Actual Rendering
bug with DateTime formatter
Posted: Tue May 10, 2011 9:16 am
Hello,
Your screenshots are not visible. Could you, please upload screenshots.
Thank you.
Your screenshots are not visible. Could you, please upload screenshots.
Thank you.
bug with DateTime formatter
Posted: Tue May 10, 2011 9:38 am
Odd, I see them. And...on refresh, they are gone...Ok...no twitpic uploads for me... back to my old way.Andrew wrote:Hello,
Your screenshots are not visible. Could you, please upload screenshots.
Thank you.
// should be better now //
bug with DateTime formatter
Posted: Tue May 10, 2011 9:42 am
Now I see them.
Thank you.
Thank you.