bug with DateTime formatter

brianj774 · Post by **brianj774** » Thu Apr 21, 2011 2:51 pm

See the image below:

http://twitpic.com/4nphdp

Post by **Vladimir** » Fri Apr 22, 2011 1:43 am

Hello,

Please tell us how you connect the data to the report?

Thank you.

brianj774 · Post by **brianj774** » Mon Apr 25, 2011 2:14 pm

http://forum.stimulsoft.com/Default.aspx?g=posts&t=4073

Post by **Vladimir** » 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.

brianj774 · Post by **brianj774** » Fri May 06, 2011 11:06 am

From the May 04 release, I see :

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.

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...

Code: Select all

{Year(QDeposit.OrderDate)}-{Month(QDeposit.OrderDate)}-{Day(QDeposit.OrderDate)}

Code: Select all

{DateToStr(QDeposit.OrderDate)}

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!

Post by **Vladimir** » Tue May 10, 2011 5:02 am

Hello,

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-09

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:

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:00

Thank you.

brianj774 · Post by **brianj774** » Tue May 10, 2011 7:59 am

Sadly, that still isn't working for me...

Field Properties

Header Definition

Actual Rendering

Post by **Andrew** » Tue May 10, 2011 9:16 am

Hello,

Your screenshots are not visible. Could you, please upload screenshots.

Thank you.

brianj774 · Post by **brianj774** » Tue May 10, 2011 9:38 am

Andrew wrote:Hello,

Your screenshots are not visible. Could you, please upload screenshots.

Thank you.

Odd, I see them. And...on refresh, they are gone...Ok...no twitpic uploads for me... back to my old way.

// should be better now //

Post by **Andrew** » Tue May 10, 2011 9:42 am

Now I see them.

Thank you.