I need to do like that: if today is Monday returns "xxx1" , if Sunday returns "xxx7".
If using xxx%ICUDateTime%e%, got wrong result.
How to do that?
Can you show your macro, at least the relevant action(s)?
I tried it and it seems to work fine:
The only issue is that I was expecting "3" for "Wed" (my local day today) instead of "4".
My code is the same as you, showing "xxx4", but today is Wednesday in my country, should be showing "xxx3" instead.
Thanks for the clarification. Just by looking at your OP, I would not know you are having the same issue I said in my reply.
It looks like the counting begins with Sunday.
One way to get what you wanted is to minus 1 day:
1 Like
It works, thank you!
As an alternative you could use KM’s DOW() function. See the wiki https://wiki.keyboardmaestro.com/function/DOW
It returns 1 for Sunday, 2 for Monday, etc.
But @cmichaelaq wants 1 for Monday, 2 for Tuesday, etc.
Is it possible to get the wanted result from DOW()? I'd like to learn, as DOW() is more intuitive.
1 Like
DOW example:
also, you can do a comparison,
that if Today is SpecificDay, then return True
ie today is Wednesday = true:
Hi @hello, as @tiffle said, DOW() return 1 for Sunday, 2 for Monday, etc.
But @cmichaelaq wanted to return 7 for Sunday, 1 for Monday, etc.
My question is about how to use DOW() (if possible) to get what @cmichaelaq wanted.
Currently, only %ICUDateTimeMinus%1%Days%e% gets what is asked of.
See:
Hi @martin, this is how I'd use DOW() in this situation:
The first action just creates a look-up table so that:
1 (Sunday) maps to "7"
2 (Monday) maps to "1"
3 (Tuesday) maps to "2"
etc.
(assuming Sunday is to be 7, Monday is to be 1, etc.)
The second actions then uses DOW() to extract the correct value from the look-up table.
It works but it's not really what I'd call elegant!
5 Likes
It might not be elegant, but it is brilliant. I would never be able to come up with a solution like this. Well done!
1 Like
Or just use this (elegant?) calculation: %Calculate%1+((DOW()+5) MOD 7)%
2 Likes
Thanks @SLWorona - I was searching for this elegant and brilliant solution of yours but just couldn't get my brain in gear! Much better!
1 Like
1 Like
Or this (so simple...) calculation: DOW()-1+7*(DOW()=1)
2 Likes
That’s very clever avoiding modulo arithmetic!
1 Like