DateTime Formula

[stevess]

Hi,

Someone should know the answer to this.

I have a datetime field that I want to create a formula on.
I need to show any date that is current date + 3 months in advance.

The data is stored as 10/07/02 00:00:00

Cheers.

Steve

 

[dgillz]

Dateadd("m",3,Date({DateTimeField})) should do the trick. If you do not have the dateadd() function - which made its debut in CR V8 - it is available for download at the crystal decisions website. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[goranm]

Hi !

You can use the function "DateAdd" (came with version 8).

DateAdd( 'm', 3 , currentdate ) will give you a date that is 3 months in advance.

If you have version 6 or 7 of Crystal Reports, there is a dll that you can download to get the function.

Go to

http://support.crystaldecisions.com/updates/

· Search for UFLDateAdd.exe

/Goran

 

[stevess]

Sorry people, I didn't explain properly what I was after.

This may help explain.

Say I have some renewal dates in the system of
25/8/01
14/9/01
25/9/01
28/10/01

My report needs to look at the date, forget about year.
We need to inform our customers when the renewal is due in 3 months time.

So if I run the report to day, I should see
25/8/01
14/9/01
25/9/01

Can this be done?!?!

Cheers.

Steve

 

[dgillz]

Steve,

Why would you only see 3 of the 4 records? Please explain. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[stevess]

Hi,

I will only see the first 3 as they would be up for renewal in the next 3 months.

Cheers.

Steve

 

[Naith]

Seriously Steve, I think what dgillz and Goran have already told you is what you really want.

Just display dates where {Renewal Date} <= Dateadd(&quot;m&quot;,3,{CurrentDate})

Naith

 

[dgillz]

In yuor record selection formula use this:

{Renewal Date} in CurrentDate to Dateadd(&quot;m&quot;,3,{CurrentDate})

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com