Gallery
Share
Explore

icon picker
Sign examples

Apply Sign() instead of SwitchIf()
As mentioned in my blog, see below. It was Joost who showed me the super powers of Sign().

⁠
How to Coda with Sign()
Shorten and simplify your code
huizer.medium.com
⁠
⁠


⁠
Sign examples
1
startDate
birthDay
endDate
next birthday based on today
years subtracted
get time span
get the sign value
add min to sign
give me the year
sign applied by Joost
1
2008-10-08, 22:00:00
08/10/2008, 22:00:00
2011-04-03, 22:00:00
10/8/2024
3
188 days ago
-1
-1
2
2 years 5 months 26 days
2
1985-04-25, 22:00:00
25/04/1985, 22:00:00
2008-10-08, 22:00:00
4/25/2025
23
166 days
1
0
23
23 years 5 months 13 days
3
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2424-12-31, 13:30:00
12/31/2024
401
30 mins ago
-1
-1
400
400 years 11 months 30 days 23 hrs 30 mins
4
2024-02-29, 00:00:00
29/02/2024, 00:00:00
2028-02-28, 00:00:00
3/1/2025
4
1 day ago
-1
-1
3
3 years 11 months 27 days
5
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-31, 12:30:00
12/31/2024
1
275 days 1 hr 30 mins ago
-1
-1
0
2 months 30 days 22 hrs 30 mins
6
2000-03-01, 04:30:00
01/03/2000, 04:30:00
2045-03-25, 04:30:00
3/1/2025
45
24 days
1
0
45
45 years 24 days
7
2022-02-03, 14:00:00
03/02/2022, 14:00:00
2022-03-03, 14:00:00
2/3/2025
0
28 days
1
0
0
1 month
8
2024-02-28, 14:00:00
28/02/2024, 14:00:00
2028-02-28, 14:00:00
2/28/2025
4
-
0
0
4
4 years
9
2023-02-28, 01:00:00
28/02/2023, 01:00:00
2023-03-28, 01:00:00
2/28/2025
0
28 days
1
0
0
1 month
10
2023-01-01, 14:00:00
01/01/2023, 14:00:00
2023-12-31, 14:00:00
1/1/2025
0
364 days
1
0
0
11 months 30 days
11
2022-03-05, 11:00:00
05/03/2022, 11:00:00
2046-05-15, 11:00:00
3/5/2025
24
71 days
1
0
24
24 years 2 months 10 days
12
2022-08-08, 11:00:00
08/08/2022, 11:00:00
2032-05-11, 10:30:00
8/8/2024
10
89 days 30 mins ago
-1
-1
9
9 years 9 months 2 days 23 hrs 30 mins
13
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-01, 12:30:00
12/31/2024
1
305 days 1 hr 30 mins ago
-1
-1
0
2 months 22 hrs 30 mins
14
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-02, 12:30:00
12/31/2024
1
304 days 1 hr 30 mins ago
-1
-1
0
2 months 1 day 22 hrs 30 mins
15
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-03, 12:30:00
12/31/2024
1
303 days 1 hr 30 mins ago
-1
-1
0
2 months 2 days 22 hrs 30 mins
16
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-04, 12:30:00
12/31/2024
1
302 days 1 hr 30 mins ago
-1
-1
0
2 months 3 days 22 hrs 30 mins
17
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-05, 12:30:00
12/31/2024
1
301 days 1 hr 30 mins ago
-1
-1
0
2 months 4 days 22 hrs 30 mins
18
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-06, 12:30:00
12/31/2024
1
300 days 1 hr 30 mins ago
-1
-1
0
2 months 5 days 22 hrs 30 mins
19
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-07, 12:30:00
12/31/2024
1
299 days 1 hr 30 mins ago
-1
-1
0
2 months 6 days 22 hrs 30 mins
20
2000-03-31, 14:00:00
31/03/2000, 14:00:00
2001-03-31, 14:00:00
3/31/2025
1
-
0
0
1
1 year
21
2020-09-14, 14:00:00
14/09/2020, 14:00:00
2044-10-01, 14:00:00
9/14/2024
24
17 days
1
0
24
24 years 17 days
22
2020-07-14, 14:00:00
14/07/2020, 14:00:00
2021-09-14, 13:30:00
7/14/2025
1
61 days 23 hrs 30 mins
1
0
1
1 year 1 month 30 days 23 hrs 30 mins
23
2023-12-31, 23:00:00
31/12/2023, 23:00:00
2424-12-31, 23:00:00
12/31/2024
401
-
0
0
401
401 years
24
2023-10-16, 23:00:00
16/10/2023, 23:00:00
2023-10-17, 23:00:00
10/16/2024
0
1 day
1
0
0
1 day
25
2023-10-17, 02:00:00
17/10/2023, 02:00:00
2024-10-17, 02:00:00
10/17/2024
1
-
0
0
1
1 year
26
2024-01-29, 14:00:00
29/01/2024, 14:00:00
2024-03-01, 14:00:00
1/29/2025
0
32 days
1
0
0
1 month 1 day
27
2023-01-28, 00:30:00
28/01/2023, 00:30:00
2023-02-28, 01:00:00
1/28/2025
0
31 days 30 mins
1
0
0
1 month 30 mins
28
2023-01-01, 09:00:00
01/01/2023, 09:00:00
2023-12-31, 09:30:00
1/1/2025
0
364 days 30 mins
1
0
0
11 months 30 days 30 mins
29
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-03-01, 14:00:00
12/31/2024
1
305 days ago
-1
-1
0
2 months 1 day
30
2023-12-31, 14:00:00
31/12/2023, 14:00:00
2024-04-01, 14:00:00
12/31/2024
1
274 days ago
-1
-1
0
3 months 1 day
31
2023-03-31, 17:00:00
31/03/2023, 17:00:00
2023-05-30, 17:00:00
3/31/2025
0
60 days
1
0
0
1 month 30 days
32
2020-07-16, 10:00:00
16/07/2020, 10:00:00
2036-04-06, 11:00:00
7/16/2025
16
100 days 23 hrs ago
-1
-1
15
15 years 8 months 21 days 1 hr
33
2022-05-12, 11:00:00
12/05/2022, 11:00:00
2042-09-05, 11:00:00
5/12/2025
20
116 days
1
0
20
20 years 3 months 24 days
34
2022-05-12, 11:00:00
12/05/2022, 11:00:00
2042-09-05, 10:30:00
5/12/2025
20
115 days 23 hrs 30 mins
1
0
20
20 years 3 months 23 days 23 hrs 30 mins
35
2020-08-09, 12:30:00
09/08/2020, 12:30:00
2035-12-12, 14:30:00
8/9/2024
15
125 days 2 hrs
1
0
15
15 years 4 months 3 days 2 hrs
36
2021-02-26, 11:00:00
26/02/2021, 11:00:00
2047-11-24, 12:00:00
2/26/2025
26
271 days 1 hr
1
0
26
26 years 8 months 29 days 1 hr
37
2024-03-01, 12:00:00
01/03/2024, 12:00:00
2025-03-01, 12:00:00
3/1/2025
1
-
0
0
1
1 year
38
2023-10-18, 12:00:00
18/10/2023, 12:00:00
2023-10-18, 12:00:00
10/18/2024
0
-
0
0
0
​
39
2024-02-29, 01:00:00
29/02/2024, 01:00:00
2028-02-29, 01:00:00
3/1/2025
4
-
0
0
4
4 years
40
2023-09-08, 19:00:00
08/09/2023, 19:00:00
2023-10-12, 19:00:00
9/8/2024
0
34 days
1
0
0
1 month 4 days
41
2000-03-24, 04:50:03
24/03/2000, 04:50:03
2045-03-31, 03:15:13
3/24/2025
45
6 days 22 hrs 25 mins 10 secs
1
0
45
45 years 6 days 22 hrs 25 mins 10 secs
42
2000-03-25, 04:30:00
25/03/2000, 04:30:00
2045-03-25, 04:30:00
3/25/2025
45
-
0
0
45
45 years
43
2023-10-14, 14:00:00
14/10/2023, 14:00:00
2024-10-14, 13:30:00
10/14/2024
1
30 mins ago
-1
-1
0
11 months 29 days 23 hrs 30 mins
44
2023-10-19, 15:00:00
19/10/2023, 15:00:00
2024-10-19, 13:30:00
10/19/2024
1
1 hr 30 mins ago
-1
-1
0
11 months 29 days 22 hrs 30 mins
45
2023-08-29, 00:00:00
29/08/2023, 00:00:00
2023-08-29, 00:02:00
8/29/2024
0
2 mins
1
0
0
2 mins
46
2023-08-29, 00:00:00
29/08/2023, 00:00:00
2023-08-29, 01:30:00
8/29/2024
0
1 hr 30 mins
1
0
0
1 hr 30 mins
47
2023-08-27, 00:00:00
27/08/2023, 00:00:00
2023-08-29, 01:30:00
8/27/2024
0
2 days 1 hr 30 mins
1
0
0
2 days 1 hr 30 mins
48
2023-08-30, 08:00:00
30/08/2023, 08:00:00
2023-09-06, 08:00:00
8/30/2024
0
7 days
1
0
0
7 days
49
2023-11-30, 14:00:00
30/11/2023, 14:00:00
2024-08-14, 13:30:00
11/30/2024
1
108 days 30 mins ago
-1
-1
0
8 months 14 days 23 hrs 30 mins
50
2023-04-01, 02:00:00
01/04/2023, 02:00:00
2023-05-01, 02:00:00
4/1/2025
0
30 days
1
0
0
1 month
51
2023-12-31, 08:10:00
31/12/2023, 08:10:00
2024-02-29, 08:00:00
12/31/2024
1
306 days 10 mins ago
-1
-1
0
1 month 28 days 23 hrs 50 mins
There are no rows in this table
⁠

Below (left) a function to get the age, this is an often applied logic, right the signed version
Today().Year() - thisRow.birthday.Year() -
If(
Date(
Today().Year(),
thisRow.birthday.Month(),
thisRow.birthday.Day()
) >
Today(),
1,
0
)

Min(0,
Sign(
Today() -
Date(
Today().Year(),
thisRow.birthDay.Month(),
thisRow.birthDay.Day()
)
)
) + Today().Year() - thisRow.birthDay.Year()

⁠
EU Formats
1
birthDay
nextBirthDayEU
ageNormal
i
ageSign
step01Sign
i
step02Sign
i
step03Sign
i
1
08/10/2008, 22:00:00
10/8/2024
15
15
63 days ago
-1
15
2
25/04/1985, 22:00:00
4/25/2025
39
39
103 days
1
39
3
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
4
29/02/2024, 00:00:00
3/1/2025
0
0
159 days
1
0
5
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
6
01/03/2000, 04:30:00
3/1/2025
24
24
158 days
1
24
7
03/02/2022, 14:00:00
2/3/2025
2
2
185 days
1
2
8
28/02/2024, 14:00:00
2/28/2025
0
0
160 days
1
0
9
28/02/2023, 01:00:00
2/28/2025
1
1
160 days
1
1
10
01/01/2023, 14:00:00
1/1/2025
1
1
218 days
1
1
11
05/03/2022, 11:00:00
3/5/2025
2
2
154 days
1
2
12
08/08/2022, 11:00:00
8/8/2024
1
1
2 days ago
-1
1
13
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
14
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
15
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
16
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
17
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
18
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
19
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
20
31/03/2000, 14:00:00
3/31/2025
24
24
128 days
1
24
21
14/09/2020, 14:00:00
9/14/2024
3
3
39 days ago
-1
3
22
14/07/2020, 14:00:00
7/14/2025
4
4
23 days
1
4
23
31/12/2023, 23:00:00
12/31/2024
0
0
147 days ago
-1
0
24
16/10/2023, 23:00:00
10/16/2024
0
0
71 days ago
-1
0
25
17/10/2023, 02:00:00
10/17/2024
0
0
72 days ago
-1
0
26
29/01/2024, 14:00:00
1/29/2025
0
0
190 days
1
0
27
28/01/2023, 00:30:00
1/28/2025
1
1
191 days
1
1
28
01/01/2023, 09:00:00
1/1/2025
1
1
218 days
1
1
29
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
30
31/12/2023, 14:00:00
12/31/2024
0
0
147 days ago
-1
0
31
31/03/2023, 17:00:00
3/31/2025
1
1
128 days
1
1
32
16/07/2020, 10:00:00
7/16/2025
4
4
21 days
1
4
33
12/05/2022, 11:00:00
5/12/2025
2
2
86 days
1
2
34
12/05/2022, 11:00:00
5/12/2025
2
2
86 days
1
2
35
09/08/2020, 12:30:00
8/9/2024
3
3
3 days ago
-1
3
36
26/02/2021, 11:00:00
2/26/2025
3
3
162 days
1
3
37
01/03/2024, 12:00:00
3/1/2025
0
0
158 days
1
0
38
18/10/2023, 12:00:00
10/18/2024
0
0
73 days ago
-1
0
39
29/02/2024, 01:00:00
3/1/2025
0
0
159 days
1
0
40
08/09/2023, 19:00:00
9/8/2024
0
0
33 days ago
-1
0
41
24/03/2000, 04:50:03
3/24/2025
24
24
135 days
1
24
42
25/03/2000, 04:30:00
3/25/2025
24
24
134 days
1
24
43
14/10/2023, 14:00:00
10/14/2024
0
0
69 days ago
-1
0
44
19/10/2023, 15:00:00
10/19/2024
0
0
74 days ago
-1
0
45
29/08/2023, 00:00:00
8/29/2024
0
0
23 days ago
-1
0
46
29/08/2023, 00:00:00
8/29/2024
0
0
23 days ago
-1
0
47
27/08/2023, 00:00:00
8/27/2024
0
0
21 days ago
-1
0
48
30/08/2023, 08:00:00
8/30/2024
0
0
24 days ago
-1
0
49
30/11/2023, 14:00:00
11/30/2024
0
0
116 days ago
-1
0
50
01/04/2023, 02:00:00
4/1/2025
1
1
127 days
1
1
51
31/12/2023, 08:10:00
12/31/2024
0
0
147 days ago
-1
0
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.