@DATE Get Date for Prior/Next Day of Week [Example]

Macro Library
,
1

MACRO:   @DATE Get Date for Prior/Next Day of Week [Example]

VER: 2.4    2016-12-27 ~~~

DOWNLOAD:

@DATE Get Date for Prior-Next Day of Week [Example].kmmacros (12 KB)

ReleaseNotes

Author.@JMichaelTX

PURPOSE:

  • Get the Date for the NEXT or PRIOR Day of Week (Sun, Mon, Tue, ...)

HOW TO USE:

  1. Set the Day of Week Number in the magenta-colored Action below
    (1 = Sun; Negative for PRIOR, Positive for NEXT)
    .
  2. Trigger this Macro

NOTE: If the Next/Prior Day requested is the same day of week as today, then it wlll return one week from today.

REFERENCE:

VERSION HISTORY

2.4 2016-12-27 1:55 PM CT

  • Fixed bug in PRIOR Offset. New formula is:
    • (((7 - DOW( ) + ABS(DATE__DayNum)) MOD 7) ) - 7

image
image1140×2642 529 KB

1 Like
2

As of KM 8+, you may not need this macro. Check out this new feature of KM 8+:

1 Like
3

This is brilliant--made an account just to say thank you!

1 Like