Crystal Date Formula

system · March 17, 2011, 12:15pm

Try This

If {CustCnt1.CreateDate} <= DateValue(2010,06,30) then "HELLO" Else

If {CustCnt1.CreateDate} > DateValue(2010,06,30) then

If {CustCnt1.CreateDate} <= DateValue (2010,07,03)then "GOODBYE"

Else "NOT INCLUDED"

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Thursday, March 17, 2011 10:43 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Date Formula

The CustCnt.CreateDate in the xml is in this format ...

<Customer.ChangeDate>2011-02-09T00:00:00+00:00</Customer.ChangeDate>

________________________________
From: Chris Thompson <chriselectrix@... <mailto:chriselectrix%40ymail.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, 17 March, 2011 14:20:32
Subject: Re: [Vantage] Crystal Date Formula

Ive got this ...

if {ELEC01_CustomersAndContacts__Summary.CustCnt.CreateDate} <= 30/06/10 then
'hello'

But its now highlighting 30/06/10 and saying a date and time is required. I have

tried apostrophes around it. I have now tried it with # # around it.

Still doesnt seem to be working.

The above formula is just putting 'hello' next to everything that hasnt got a
date.

I have used an outer joing Customer > CustCnt as I need to see all customers and

all contacts even if a customer doesnt have any contacts.

How can I get it to distinguish the 'null' custcnt.createdate?

________________________________
From: Scott Litzau <scott.litzau@... <mailto:scott.litzau%40olympusgrp.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, 17 March, 2011 14:10:14
Subject: RE: [Vantage] Crystal Date Formula

The format for custcnt.createdate is 99/99/99, try using a two digit year

Scott

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
Chris Thompson
Sent: Thursday, March 17, 2011 9:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Date Formula

Hi All

I want to simply add a formula to my Crystal report.

The date field is CustCnt.CreateDate.

I want to create a formula which says

If custcnt.createdate <= 30/06/2010 (UK format date) then 'Hello' else
If custcnt.createdate > 30/06/2010 and <= 07/03/2011 then 'Goodbye'

I thought I had it cracked but then I found some dates were incorrectly
marked.

Any help would be appreciated.

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 17, 2011, 10:07am

Hi All

I want to simply add a formula to my Crystal report.

The date field is CustCnt.CreateDate.

I want to create a formula which says

If custcnt.createdate <= 30/06/2010 (UK format date) then 'Hello' else
If custcnt.createdate >Â 30/06/2010 and <= 07/03/2011 then 'Goodbye'

I thought I had it cracked but then I found some dates were incorrectly marked.

Any help would be appreciated.

Thanks.

[Non-text portions of this message have been removed]

system · March 17, 2011, 10:10am

The format for custcnt.createdate is 99/99/99, try using a two digit year

Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Thursday, March 17, 2011 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date Formula

Hi All

I want to simply add a formula to my Crystal report.

The date field is CustCnt.CreateDate.

I want to create a formula which says

If custcnt.createdate <= 30/06/2010 (UK format date) then 'Hello' else
If custcnt.createdate > 30/06/2010 and <= 07/03/2011 then 'Goodbye'

I thought I had it cracked but then I found some dates were incorrectly
marked.

Any help would be appreciated.

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 17, 2011, 10:20am

Ive got this ...

if {ELEC01_CustomersAndContacts__Summary.CustCnt.CreateDate} <= 30/06/10 then
'hello'

But its now highlighting 30/06/10 and saying a date and time is required. I have
tried apostrophes around it. I have now tried it with # # around it.

Still doesnt seem to be working.

The above formula is just putting 'hello' next to everything that hasnt got a
date.

I have used an outer joing Customer > CustCnt as I need to see all customers and
all contacts even if a customer doesnt have any contacts.

How can I get it to distinguish the 'null' custcnt.createdate?

________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Thu, 17 March, 2011 14:10:14
Subject: RE: [Vantage] Crystal Date Formula

Â
The format for custcnt.createdate is 99/99/99, try using a two digit year

Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Thursday, March 17, 2011 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date Formula

Hi All

I want to simply add a formula to my Crystal report.

The date field is CustCnt.CreateDate.

I want to create a formula which says

If custcnt.createdate <= 30/06/2010 (UK format date) then 'Hello' else
If custcnt.createdate > 30/06/2010 and <= 07/03/2011 then 'Goodbye'

I thought I had it cracked but then I found some dates were incorrectly
marked.

Any help would be appreciated.

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 17, 2011, 11:43am

The CustCnt.CreateDate in the xml is in this format ...

<Customer.ChangeDate>2011-02-09T00:00:00+00:00</Customer.ChangeDate>

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Thu, 17 March, 2011 14:20:32
Subject: Re: [Vantage] Crystal Date Formula

Â
Ive got this ...

if {ELEC01_CustomersAndContacts__Summary.CustCnt.CreateDate} <= 30/06/10 then
'hello'

But its now highlighting 30/06/10 and saying a date and time is required. I have

tried apostrophes around it. I have now tried it with # # around it.

Still doesnt seem to be working.

The above formula is just putting 'hello' next to everything that hasnt got a
date.

I have used an outer joing Customer > CustCnt as I need to see all customers and

all contacts even if a customer doesnt have any contacts.

How can I get it to distinguish the 'null' custcnt.createdate?

________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Thu, 17 March, 2011 14:10:14
Subject: RE: [Vantage] Crystal Date Formula

Â
The format for custcnt.createdate is 99/99/99, try using a two digit year

Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Thursday, March 17, 2011 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date Formula

Hi All

I want to simply add a formula to my Crystal report.

The date field is CustCnt.CreateDate.

I want to create a formula which says

If custcnt.createdate <= 30/06/2010 (UK format date) then 'Hello' else
If custcnt.createdate > 30/06/2010 and <= 07/03/2011 then 'Goodbye'

I thought I had it cracked but then I found some dates were incorrectly
marked.

Any help would be appreciated.

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]