Date to Integer??

[Former Member]

Post Author: rjstassi

CA Forum: Formula

This should be an easy question...

I am creating a conditional if-then-else statement that combines date fields and number fields. All of the "help" I have looked up says to use the Date() or Datetime() function to convert the date to be compatible to add/subtract etc with a number field. Nothing works. I must be missing something simple here. Any help??

Thanks

Rick in Sacramento

[Former Member]

Post Author: rjstassi

CA Forum: Formula

Thanks for you response.

That is good advice. Can the be a variable?

I am creating a formula that uses dates (date) and durations (number):

The formula is:

if ( + {Remailing Duration})/{Total Duration} > 1.1 and ( + {Remailing Duration})/{Total Duration} <= 1.2 then ....

else if if ( + {Remailing Duration})/{Total Duration} > 1.2 then ...

else ...

I am using Crystal Syntax

Rick

[Former Member]

Post Author: bettername

CA Forum: Formula

I have the feeling you want to be looking at the DATEADD function if you are adding/subtracting values from a date (or vice-versa).

dateadd("DD",3,) will add 3 days to the value in dateadd("MM", {yourquantitity), {youdatefield}) will add months to the value in .

Let us know if this is not the case!