ToText not overloading correctly

[cancer2006]

I am using CRW8.5 and ACCESS97
I have two fields type Date/Time. Is my comparing criteria correct? The following formula is not printing the Einfo.hiredate field.

Einfo.rehiredate is also blank
whileprintingrecords;
if{EInfo.hireDate} <= {EInfo.rehireDate} then
{EInfo.rehireDate}
else
{EInfo.hireDate}

Later on I want to print the field in MM/DD/YYYY format. for this I am using the following formula.

Totext( DTSToDate({EInfo.hireDate}),"MM/dd/yyyy")

 

[lbass]

You can probably just use:

if isnull({EInfo.rehireDate}) or
{EInfo.rehireDate} = date(0,0,0) then
{EInfo.hireDate} else
{EInfo.rehireDate}

No need for "whileprintingrecords". You can also just right click on the above formula->format field->date and select the format you want.

-LB

 

[cancer2006]

Your suggestion worked but I had to modify the format option as follows:
totext({EInfo.rehireDate},"MM/dd/yyyy")



What was wrong in my formula? was my approach not logical. can you give me some guidelines on how to improve on writing logical if-then statements. Thanks.

 

[lbass]

You should be formatting the formula itself, not one field within the formula, and there is not need for a formula to do this. Just right click on the formula->format field->date and if the format you want isn't shown in that list, go to customize-> and make your selections there.

You have to check for nulls first, or the null check won't work. When you just compared dates, CR would automatically compare only non-null values.

Also, you should only use "whileprintingrecords" when necessary, since using it will mean the formula won't be available for inserted summaries.

-LB

 

[cancer2006]

I have inserted the fields in a text box with comma separated.
There is no option to customize format for formula fields. The customize option is available when the field is directly from DB.

Thanks for that null checking tip. This will make my job much easier.