Results 1 to 4 of 4

Thread: Extract weekday from a date

  1. #1

    Default Extract weekday from a date

    I can't figure this out. I know you can do it in excel - but if I want to analyze if a date is a given day of the week e.g. Friday, how do I do that?

  2. #2

    Default

    I just had an idea. Though ideally there would be a function for this, I just need to know what one arbitrary date is and then do a dateSubtract, divide by seven and use the remainder.

  3. #3
    Lavastorm Employee
    Join Date
    Apr 2014
    Location
    Boston, MA
    Posts
    279

    Default

    Hi, Daniel! Take a look at the 'weekday' function. It gives you values of 0-6 given a date (0 is Sunday).

  4. #4

    Default

    What? How did I miss that? I looked through the online help, I looked through the date/time functions listed in the right click menu.

    Doh.

    Thanks Roger!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •