TextColor & Date Field

[mav]

The 'TextColor' function wihtin the Custom Function (CF) is working for the fields formatted as Text fields, but not the Date field.

I tried using a GetAsText (field) within the CF, but that didn't help.

I've attached a file showing what's going on, it looks like a simple one, but don't they always ?

Thanks in advance . . .

TextColor.zip

[LaRetta]

Text formatting functions are designed for text fields. If you need to colorize a date field you will need to create a calculation (text) with the date field then perform the format function on that text calculation.

I've read that 8.5 allows colorizing numbers (which are field-formatted as numbers). It doesn't sound like it has changed for date fields however...

[ino]

ChangeColor ( Flag ; GetAsText ( DateText ))

That’s it ...

Ino :goodluck:

[mav]

To ino,

I have tried that, as I mentioned, but I can't get it to work . . .

Please feel free to edit my sample file with your method to demonstrate.

To LaRetta,

That's what I thought, I'll need to allow editing of a date field 'underneath' a text field that displays the formatting . . .

mav.