if then else date formula

[wanzek1]

I am struggling with a formula for a fixed width report. Our system puts a default date of 1/0/1900. I have used a variation or this formula in the past and have never had any problems but I haven't ever needed a place holder of eight spaces if the field is 1/0/1900.

if {HRRM.udOrigHireDate} > #1950/01/01# then {HRRM.udOrigHireDate}
else if {HRRM.udOrigHireDate} < #1950/01/01# then space(8)

I got an error message saying a date is required here.

Thanks!

 

[kray4660]

I do not believe using the #'s will work for dates in Crystal Reports. There is a date function, I believe it takes the dates in the form mm/dd/yyyy as as string.

I hope this helps.

 

[wanzek1]

If I take the pound signs out it highlights the 01/01/1950 and says a date is required here.

 

[Charliy]

date(1950,1,1)

 

[wanzek1]

if {HRRM.udOrigHireDate} > date(1950,1,1) then {HRRM.udOrigHireDate}
else if {HRRM.udOrigHireDate} < date(1950,1,1) then space(8)

I changed this using date instead of the # and I still get the same message saying a date is required here.

The problem in the formula is not anything with the dates. It is with the space(8)

 

[pmax9999]

The problem is that you are mixing the data type results of the if-then-else statement (a string or a date) which won't work. If you want to use a blank string to indicate no date you could use:

If 	{HRRM.udOrigHireDate} > Date(1950,1,1) 
Then 	ToText({HRRM.udOrigHireDate}, 'dd/MM/yyyy')
Else	''

I don't have access to Crystal to check my syntax so apologies if it isn't quite right. If you need the date in a different format, just change the last part of the "Then" line.

Cheers
Pete

 

[wanzek1]

That doesn't give me what I need though. I need a place holder for 8 spaces if the field is less than 1/1/1950.

 

[fisheromacse]

i do not have crystal in front of me, but maybe.....

depending on if you are using the date returned as a date in some other location of the report, but you could create a new formula just for the display something like this:

if {HRRM.udOrigHireDate} < dateserial(1950,01,01) then " "
else totext({HRRM.udOrigHireDate},0)

 

[pmax9999]

In that case, just change the Else statement in my code to a string of 8 spaces.