Jump to content

TextColor & Date Field


This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.