0

Find weekends dates

Is there some code to detect weekends in a list of Dates.  Now I have a list of 2500 dates records and I need to know which ones are weekends.

Thanks

3 replies

null
    • Danjamesmedia
    • 1 yr ago
    • Reported - view
    let inputDate := Date;
format(inputDate, "d") = 6 or format(inputDate, "d") = 0

     

    "d" in the format outputs the day of the week as a number 0 - 6

    0 = Sunday

    1 = Monday

    ...

    6 = Saturday

    This will output True if the Date is a Saturday/Sunday

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Dan James (Ninox Partner) 

      Thanks Dan 馃憤

    • Kennes Digital
    • Stefanie_Kennes
    • 1 yr ago
    • Reported - view

    weekday(date) works too.

    https://docs.ninox.com/en/script/functions-overview#weekday

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 51Views
  • 3 Following