Technical Questions: selecting dates

Print Page | Close Window

selecting dates

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3482
Printed Date: 29 Apr 2024 at 9:45am

Topic: selecting dates

Posted By: twinkle
Subject: selecting dates
Date Posted: 19 Jun 2008 at 3:58am

Hi,

I am trying to get items that have gone past a certain date but don't want to include anything that is older then from year 2006

I have the following formula

if isnull({TargetClose}) = true then datetimevalue("01/01/2020") else {TargetClose}

What else do i need within this formula please?

Print Page | Close Window