calculation/result type

[mcourtney]

I have a layout with places for some dates. What I'd like to have happen is, for the date to show up if it's been entered, or if not, a series of underlines to give the user of the layout a place to write in the date. I've set up a calculation field thus:

 

Case (

 

IsEmpty ( a_SelectDate );

 

"_________";

 

a_SelectDate

 

)

 

 

Which works fine, except that if I use text as the calculation result, I get the date in raw format ("526794") and if I use the date result, it won't process the series of lines and I just get a question mark. Any ideas?

 

 

Thanks!

[mcourtney]

Oh wait. Now it's decided to work. Apparently in the process of fiddling around with it I fixed it. Wish I knew how.

[doughemi]

Well, "___________" isn't a valid date, so you can't use that in a date field (as you now know. )

 

Case ( 
IsEmpty ( a_SelectDate );
"_________";
GetAsText(a_SelectDate)
)

with a text result should have done it.

 

--Doug