Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to get day names?

Discussion in 'Information Technology' started by danijela.simunovic@gmail.com, Oct 31, 2005.

Tags:
  1. danijela.simunovic@gmail.com

    Guest

    I'm sorry for posting so many questions but this group has been very
    helpfull so far and i have a lot of questions so i appriciate your help
    very much!

    I have a table with dates(1.1.2001.),how can i make a query which would
    have two columns:the first would be the dates from the dates table and
    the second would be the day names(Monday,Tuesday...Friday...) I know
    that the day names are "dddd" but what do i do with that to get the day
    name from a specific date?
    Thanks!

    Danijela
     
  2. Loading...

    Similar Threads Forum Date
    Politics These are the names of 21 children killed in Gaza Breaking News Jul 12, 2014
    Sikh Names... Ideas? Sikh Sikhi Sikhism Jul 5, 2014
    Canada Canada names park after first Sikh settler Breaking News Jan 15, 2014
    India Sikhs of Northeast, South India Don't Flaunt Surnames: Study Breaking News Aug 29, 2013
    Canada Employers Favour English-sounding Names Breaking News Oct 14, 2011

  3. danijela.simunovic@gmail.com

    Guest

    I solved this problem, it was easy. I used the Weekday and WeekdayName
    function but i still don't know what abbreviate means- i put for
    abbreviate and the query works just fine.

    WeekdayName(weekday, abbreviate, firstdayofweek)
    WeekdayName(Weekday(qryDate!Date);2;1)
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On 30 Oct 2005 08:40:41 -0800, danijela.simunovic@gmail.com wrote:

    > I'm sorry for posting so many questions but this group has been very
    > helpfull so far and i have a lot of questions so i appriciate your help
    > very much!
    >
    > I have a table with dates(1.1.2001.),how can i make a query which would
    > have two columns:the first would be the dates from the dates table and
    > the second would be the day names(Monday,Tuesday...Friday...) I know
    > that the day names are "dddd" but what do i do with that to get the day
    > name from a specific date?
    > Thanks!
    >
    > Danijela


    Select YourTable.[DateField], Format([DateField],"dddd") as DayName
    From YourTable;


    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  5. danijela.simunovic@gmail.com

    Guest

    I figured out what abbreviate means and how it works-i'm so happy! :)
     

Share This Page