|
The function returns the weekday number of
the date given. Returns:
Sunday – 1 Monday – 2 Tuesday – 3 Wednesday – 4 Thursday –
5 Friday – 6 Saturday – 7
WEEKDAY(Date)
PARAMETERS
DATE
Any date.
Example: To
return the ‘weekday’ from the date contained in a textbox with TAG name of
InvoiceDate:
TEST(WEEKDAY(~InvoiceDate~)//=//7) MESSAGE(“This
invoice was on a
Saturday!”//”Test”) EXIT() ENDTEST()
TEST(WEEKDAY(~InvoiceDate~)//=//1) MESSAGE(“This
invoice was on a
Sunday!”//”Test”) EXIT() ENDTEST()
MESSAGE(“This invoice was
on a weekday!”//”test”)
|