Crystal Reports Converting a date filed from a string

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Converting a date filed from a string

Author	Message
jbattelle Newbie Joined: 06 Feb 2012 Location: United States Online Status: Offline Posts: 25	Topic: Converting a date filed from a string Posted: 11 Jan 2013 at 6:29am
	OK, for the life of me, I can't figure this out. I have a date field that comes in as a string, and it is formatted as follows: YYYYMM I would like it to display as MM/YYYY so I can filter, etc. Essentially, this is for Past Due balance report so I will want to be able to display data in a desired date range.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 11 Jan 2013 at 8:36am
	If you just want to use for display purposes and not calculations. right({stringvalue},2)+"/"+left({stringvalue]),4)
	IP Logged

jbattelle Newbie Joined: 06 Feb 2012 Location: United States Online Status: Offline Posts: 25	Posted: 11 Jan 2013 at 9:56am
	Actually, I would need to make calcs. Do you know what would work for that?
	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.035 seconds.