Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Year formatting Post Reply Post New Topic
Author Message
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Topic: Year formatting
    Posted: 04 Oct 2011 at 7:57pm
Hi All,

In crystal reports XI, i am trying to get the year from a date field but that is pulling with semi colon like 2,011 but i want to get 2011, pls suggest me.

the code that i am using is like below:

totext(year(DateAdd("M",-5,{tablename.GL Date})),0)
Regards
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 04 Oct 2011 at 8:41pm
i got it through replace function..
Regards
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.