Hello I try without success a formula around the
Day of the week.
Thanks Günter
Hallo ich versuche ohne erfolg eine Formel um den
Wochentag anzuzeigen.
Thanks Günter
Display weekday
4 posts
• Page 1 of 1
Display weekday
by Günter » Fri Apr 21, 2017 9:24 am
- Günter
- Posts: 5
- Joined: Mon Dec 16, 2013 3:23 am
Re: Display weekday
by aa6vhDave » Mon Apr 24, 2017 9:47 am
Take the date, and do a modolus of 7 (divide by 7, take remainder). The value of 0 is Friday, 1 is Saturday, and so forth.
I created a linked table with the weekday names, and just link the above value to that table to get the name.
I created a linked table with the weekday names, and just link the above value to that table to get the name.
- aa6vhDave
- Posts: 57
- Joined: Mon Aug 19, 2013 1:42 pm
Re: Display weekday
by aa6vhDave » Mon Apr 24, 2017 12:42 pm
- aa6vhDave
- Posts: 57
- Joined: Mon Aug 19, 2013 1:42 pm
4 posts
• Page 1 of 1
Return to HanDBase for Android
Who is online
Users browsing this forum: No registered users and 2 guests