... the .addDay(), check none of these are a Sunday, and move the next few days along:
thisDate = '2021-10-30';
v_Today = thisDate;
v_Tomorrow = v_Today.addDay(1);
v_NextDay = v_Today.addDay(2);
if(v_Today.getDayOfWeek()==1)
{
v_Today ...
... of Month")
{
v_NextMonthDate = zoho.currentdate.addMonth(1);
v_NextMonthDateFirst = v_NextMonthDate.toStartOfMonth();
if(v_NextMonthDateFirst.getDayOfWeek()!=2)
{
for each ...
What?
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday").
Why?
If I use the toString() function to get the day, it only returns the first 3 letters ...
... DATENAME(dd, getdate())
Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate())
Month Name MONTHNAME(now()) DATENAME(mm, getdate())
Month Number MONTH(now()) DATEPART(mm, getdate())
European Date ...
... have to deal with hour changes and the magical 23:00 hour.
-- 2nd Note: We use "WEEKDAY" instead of "DAYOFWEEK" as our working week starts on Monday (Mon=0, Tue=1, Sun=6).
User Mon Tue Wed Thu Fri Sat Sun Total Days
--------------- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.