Discussions

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

Colourize the words or the background shading?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

The words, please

------------------------------
BuildPro
------------------------------

Original Message:
Sent: 05-10-2022 15:18
From: Mark Shnier (YQC)
Subject: Colorize words

Colourize the words or the background shading?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

try this

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");



var text DateWords =
$DayName
& ", "
&Case(Month($MyDate),
1,"January",
2,"February",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December")
& " "
&ToText(Day($MyDate));

var text Color = 
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

"<font color=" & $Color & ">" & $DateWords



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")
&""

var text Color =
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

&ToText(Day($MyDate));

"<font color=" & $Color & ">" & $DateWords

------------------------------
BuildPro
------------------------------

Original Message:
Sent: 05-10-2022 15:41
From: Mark Shnier (YQC)
Subject: Colorize words

try this

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");



var text DateWords =
$DayName
& ", "
&Case(Month($MyDate),
1,"January",
2,"February",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December")
& " "
&ToText(Day($MyDate));

var text Color = 
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

"<font color=" & $Color & ">" & $DateWords



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

Got It to partially work...but is returning this



var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")
&""
&ToText(Day($MyDate));

var text Color =
Case(DayOfWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");



"<font color=" & $Color & ">" & $MyDate

------------------------------
BuildPro
------------------------------

Original Message:
Sent: 05-10-2022 15:50
From: BuildPro
Subject: Colorize words



var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")
&""

var text Color =
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

&ToText(Day($MyDate));

"<font color=" & $Color & ">" & $DateWords

------------------------------
BuildPro

Original Message:
Sent: 05-10-2022 15:41
From: Mark Shnier (YQC)
Subject: Colorize words

try this

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");



var text DateWords =
$DayName
& ", "
&Case(Month($MyDate),
1,"January",
2,"February",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December")
& " "
&ToText(Day($MyDate));

var text Color = 
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

"<font color=" & $Color & ">" & $DateWords



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------

Mark,
I got it...thx

------------------------------
BuildPro
------------------------------

Original Message:
Sent: 05-10-2022 16:04
From: BuildPro
Subject: Colorize words

Got It to partially work...but is returning this



var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")
&""
&ToText(Day($MyDate));

var text Color =
Case(DayOfWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");



"<font color=" & $Color & ">" & $MyDate

------------------------------
BuildPro

Original Message:
Sent: 05-10-2022 15:50
From: BuildPro
Subject: Colorize words



var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")
&""

var text Color =
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

&ToText(Day($MyDate));

"<font color=" & $Color & ">" & $DateWords

------------------------------
BuildPro

Original Message:
Sent: 05-10-2022 15:41
From: Mark Shnier (YQC)
Subject: Colorize words

try this

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");



var text DateWords =
$DayName
& ", "
&Case(Month($MyDate),
1,"January",
2,"February",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December")
& " "
&ToText(Day($MyDate));

var text Color = 
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

"<font color=" & $Color & ">" & $DateWords



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com

Original Message:
Sent: 05-10-2022 14:54
From: BuildPro
Subject: Colorize words

I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

------------------------------
BuildPro
------------------------------