Crystal Reports Date Range Formula

Technical Questions

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

Topic: Date Range Formula

Post Reply

Post New Topic

Author	Message
karrludwig Newbie Joined: 07 Jul 2011 Location: United States Online Status: Offline Posts: 3	Topic: Date Range Formula Posted: 07 Jul 2011 at 8:57am
	Need help with this. I have two different result sets based on todays date against a creation date like client.cdtclient #1 Returns: (Parameter(New Clients) Considered to be 18 months old from todays date. #2 (Parameter(Established Clients) Older than 18 months from todays date. Any basic formula would be greatly appreciated. Karr
	IP Logged


Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 07 Jul 2011 at 9:14am
	What would be "considered" to be 18 months old from this date?
	IP Logged

karrludwig Newbie Joined: 07 Jul 2011 Location: United States Online Status: Offline Posts: 3	Posted: 07 Jul 2011 at 9:19am
	Hi. It would be the New Clients, older than that > 18 months past that date would be considered to be Established clients. Karr
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 07 Jul 2011 at 11:23am
	if client.cdtclient >= dateadd('m',-18,currentdate) then 'New Client' else if client.cdtclient < dateadd('m',-18,currentdate) then Established Client' else 'Not identified client'
	IP Logged

karrludwig Newbie Joined: 07 Jul 2011 Location: United States Online Status: Offline Posts: 3	Posted: 07 Jul 2011 at 11:43am
	Those are tears of joy! You rock. That's the one!! Thank you so much. I'll back to learn more. Karr
	IP Logged

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