Crystal Reports Date formula

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Date formula

Post Reply

Post New Topic

Author	Message
crist Newbie Joined: 21 Jun 2010 Location: Singapore Online Status: Offline Posts: 29	Topic: Date formula Posted: 21 Jun 2010 at 11:21pm
	Hi Co-Members, Please help. i need to create formula for date, where i Crystal should pull out the (ERD)estimated redelivery date versus my computer date. sample: ERD is june 17,2010 while my computer date is june 22,2010 Please help. thanks, Crist
	IP Logged


venky_115 Groupie Joined: 15 Jun 2010 Location: United States Online Status: Offline Posts: 67	Posted: 22 Jun 2010 at 12:40am
	Hi you can use CurrentDate, then it will give your computer date, Please can you explain little brief about your query, Thanks Venkat
	IP Logged

crist Newbie Joined: 21 Jun 2010 Location: Singapore Online Status: Offline Posts: 29	Posted: 22 Jun 2010 at 8:45pm
	hi, The scenario is this: I have one vessel with different voyages. Example: Voyages 1 start 1/1/2010(start date), and end date will be 6/22/2010 with Voyage 35. there are historical voyages from 1-34, right. but i want only to show in my report the last voyage i have for my ship which is voyage 35. FYI, my designed/created report showed all the voyages form start to end. Can you please help to solve this, as i need only the last voyage of my ship. Many thanks in advance. crist
	IP Logged

Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 22 Jun 2010 at 11:23pm
	try: maximum({voy_var},{vess_var}) hope it help.
	Emir W
	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