How do I convert a Date to a String?? 1

[nord]

I have a date or datetime field in the DB and I want to display spaces in the column if the date doesnt match a certain criteria. So I need to create a formula that will replace the data field which will convert the date to string, and either display the datestring or a blank.

Any solutions?

Doug

 

[synapsevampire]

You may not have to convert it, you mention two different things, one is that you want to display spaces, the other that you want to make it blank, which I take to mean display nothing (not spaces). The net viewing is similar, but exporting is not.

To convert to text:

if {MyTable.MyDate} < currentdate-7 then
totext({MyTable.MyDate})
else
&quot; / / &quot;

If you're just going to display blank, why not just use a conditional suppression?

Right click the field and select Format Field, in the X-2 formula area next to Suppression, place inb the criteria when you wish it to be suppressed.

If you don't want those rows in the report at all, enter the criteria in the record selection criteria.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[nord]

Thanks synapsevampire, you made my day!

nord