Crystal Reports Create forumula between x date and today

Report Design

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

Topic: Create forumula between x date and today

Post Reply

Post New Topic

Author	Message
shabbaranks Groupie Joined: 06 Oct 2013 Location: United Kingdom Online Status: Offline Posts: 66	Topic: Create forumula between x date and today Posted: 19 Feb 2014 at 5:17am
	Hi, Im trying to create a select expert formula which has a date set from such a point -> today. Ive tried allsorts including: ({Job_Operation_Time.Work_Date},"22-01-2011") to now() But its just not cutting the mustard - can anyone put me out of my misery please? Thank you as always :)
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 19 Feb 2014 at 8:18am
	currentdatetime
	IP Logged

shabbaranks Groupie Joined: 06 Oct 2013 Location: United Kingdom Online Status: Offline Posts: 66	Posted: 19 Feb 2014 at 9:47pm
	*Originally posted by DBlank* currentdatetime Thanks - at which point if any should I apply the brackets? As I get an error "The ) is missing. But I thought I need to bracket the field and stipulate the required date as below? ({Job_Operation_Time.Work_Date}, "22-01-20112") to currentdatetime Which obviously isn't right?
	IP Logged

shabbaranks Groupie Joined: 06 Oct 2013 Location: United Kingdom Online Status: Offline Posts: 66	Posted: 19 Feb 2014 at 11:37pm
	Got it - {Job_Operation_Time.Work_Date} in DateTime (2011, 01, 01, 00, 00, 00) to currentdatetime Thanks for the pointer :)
	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