Weird date problems 3

[dstepans]

Hello,

I have this in a formular:

stringVar result := "";
result := cstr(Year ({Claim.ServiceTo}));
result;

For the date: 1/1/03 it returns 2,003.00 Why is it formatting it like that? How could I get 2003 or 03?

I also get the same format for the Day and Month (1.0 instead of 1 or 01).

Anyway to fix it?

TIA,
Denis

 

[bdreed35]

It probably has to do with how you have numbers formatted by default. Try Right clicking the field, choose Format Field, then either highlight the correct format that you want ot choose custom and set it up.

~Brian

 

[dgillz]

Try this:

Totext(Year({YourDateField},0,"&quot



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[dstepans]

Thanks the Totext worked!

Denis

 

[Ngolem]

Another simpler Totext format would be

Totext({Table.date},"yy"}) for 2 digit year or "yyyy" for 4 digit

Similarly Totext({Table.date},"dd"}) for Day and
Totext({Table.date},"MM"}) for Month

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[dstepans]

Thanks Ngolem!