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/2024
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/2023
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
2/29/2024
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/2023
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/2024
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/2024
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/2024
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/2024
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/2024
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/2024
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/2023
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/2023
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/2023
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/2023
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/2023
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/2023
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/2023
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/2024
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/2024
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/2023
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/2024
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/2024
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/2024
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/2023
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/2023
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/2024
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/2024
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/2024
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/2024
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/2024
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/2024
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
2/29/2024
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/2024
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/2024
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/2023
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/2024
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/2023
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
46 days
1
15
2
25/04/1985, 22:00:00
4/25/2024
38
38
212 days
1
38
3
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
4
29/02/2024, 00:00:00
2/29/2024
-1
-1
267 days
1
-1
5
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
6
01/03/2000, 04:30:00
3/1/2024
23
23
267 days
1
23
7
03/02/2022, 14:00:00
2/3/2024
1
1
293 days
1
1
8
28/02/2024, 14:00:00
2/28/2024
-1
-1
268 days
1
-1
9
28/02/2023, 01:00:00
2/28/2024
0
0
268 days
1
0
10
01/01/2023, 14:00:00
1/1/2024
0
0
326 days
1
0
11
05/03/2022, 11:00:00
3/5/2024
1
1
263 days
1
1
12
08/08/2022, 11:00:00
8/8/2024
1
1
107 days
1
1
13
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
14
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
15
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
16
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
17
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
18
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
19
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
20
31/03/2000, 14:00:00
3/31/2024
23
23
237 days
1
23
21
14/09/2020, 14:00:00
9/14/2024
3
3
70 days
1
3
22
14/07/2020, 14:00:00
7/14/2024
3
3
132 days
1
3
23
31/12/2023, 23:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
24
16/10/2023, 23:00:00
10/16/2024
0
0
38 days
1
0
25
17/10/2023, 02:00:00
10/17/2024
0
0
37 days
1
0
26
29/01/2024, 14:00:00
1/29/2024
-1
-1
298 days
1
-1
27
28/01/2023, 00:30:00
1/28/2024
0
0
299 days
1
0
28
01/01/2023, 09:00:00
1/1/2024
0
0
326 days
1
0
29
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
30
31/12/2023, 14:00:00
12/31/2023
-1
-1
38 days ago
-1
-1
31
31/03/2023, 17:00:00
3/31/2024
0
0
237 days
1
0
32
16/07/2020, 10:00:00
7/16/2024
3
3
130 days
1
3
33
12/05/2022, 11:00:00
5/12/2024
1
1
195 days
1
1
34
12/05/2022, 11:00:00
5/12/2024
1
1
195 days
1
1
35
09/08/2020, 12:30:00
8/9/2024
3
3
106 days
1
3
36
26/02/2021, 11:00:00
2/26/2024
2
2
270 days
1
2
37
01/03/2024, 12:00:00
3/1/2024
-1
-1
267 days
1
-1
38
18/10/2023, 12:00:00
10/18/2024
0
0
36 days
1
0
39
29/02/2024, 01:00:00
2/29/2024
-1
-1
267 days
1
-1
40
08/09/2023, 19:00:00
9/8/2024
0
0
76 days
1
0
41
24/03/2000, 04:50:03
3/24/2024
23
23
244 days
1
23
42
25/03/2000, 04:30:00
3/25/2024
23
23
243 days
1
23
43
14/10/2023, 14:00:00
10/14/2024
0
0
40 days
1
0
44
19/10/2023, 15:00:00
10/19/2024
0
0
35 days
1
0
45
29/08/2023, 00:00:00
8/29/2024
0
0
86 days
1
0
46
29/08/2023, 00:00:00
8/29/2024
0
0
86 days
1
0
47
27/08/2023, 00:00:00
8/27/2024
0
0
88 days
1
0
48
30/08/2023, 08:00:00
8/30/2024
0
0
85 days
1
0
49
30/11/2023, 14:00:00
11/30/2023
-1
-1
7 days ago
-1
-1
50
01/04/2023, 02:00:00
4/1/2024
0
0
236 days
1
0
51
31/12/2023, 08:10:00
12/31/2023
-1
-1
38 days ago
-1
-1
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.