LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Extract weekday from a date

    Employee
    Posted 11-02-2015 12:41

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: djnrempel

    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.  RE: Extract weekday from a date

    Employee
    Posted 11-02-2015 12:44

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: djnrempel

    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.  RE: Extract weekday from a date

    Employee
    Posted 11-02-2015 12:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

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


  • 4.  RE: Extract weekday from a date

    Employee
    Posted 11-02-2015 13:00

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: djnrempel

    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!