Alpha Video Training
Results 1 to 7 of 7

Thread: Extracting day name

  1. #1
    Member
    Real Name
    Patrick Pierre-Jerome
    Join Date
    Feb 2004
    Location
    New Jersey
    Posts
    139

    Default Extracting day name

    I have a date field and a day field on a form. I need the day field to display the name of the day of the week based on the date in the date field.
    I've tried to find a function that might work, but I couldn't.
    I am using version 6.
    Any help would be appreciated.
    There is no love sincerer than the love of food.
    George Bernard Shaw

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,307

    Default

    Did you overlook CDOW() ?

    -- tom

  3. #3
    Member
    Real Name
    Patrick Pierre-Jerome
    Join Date
    Feb 2004
    Location
    New Jersey
    Posts
    139

    Default Function names

    Quote Originally Posted by Tom Cone Jr
    Did you overlook CDOW() ?

    -- tom
    Hello Tom,
    The list of functions is impressive. The trouble for me is that I have difficulty finding the function I want based on the function name. CDOW() is grouped with character functions. I spend most of my time looking through the list of date functions. I never expected to find it grouped with character functions. CDOW() gives no hint of its purpose at first glance. I was looking for a function that might have had the word date in its name. I assume "C" refers to the character value the function returns and "DOW" stands for "day of the week". Armed with that bit of knowledge, I figured out what cmonth() means.
    I'm slowly getting accustomed to this program.
    Thank you very much for your help.
    There is no love sincerer than the love of food.
    George Bernard Shaw

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default

    Quote Originally Posted by foodminer
    Hello Tom,
    The list of functions is impressive. The trouble for me is that I have difficulty finding the function I want based on the function name. CDOW() is grouped with character functions. I spend most of my time looking through the list of date functions. I never expected to find it grouped with character functions. CDOW() gives no hint of its purpose at first glance. I was looking for a function that might have had the word date in its name. I assume "C" refers to the character value the function returns and "DOW" stands for "day of the week". Armed with that bit of knowledge, I figured out what cmonth() means.
    I'm slowly getting accustomed to this program.
    Thank you very much for your help.
    Takes getting used to, I suppose. Do you use the .chm version of the Alpha Five Help, either the webhelp or downloaded? Searching for day of week, on the search tab, gets you to CDOW() pretty easily, depending on your connection speed.

  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,307

    Default

    Patrick, I used the CHM version of the Alpha Five Help system, clicked the Index tab; chose Date; chose Functions, and then visually scanned the entire list of date / time functions. Found it grouped with other "conversion" functions.

    If you're not familiar with this list of functions check it out. The explanation for CDOW() was very complete:

    Returns a character string containing the name of the day of the week for the specified Date.
    -- tom

  6. #6
    Member
    Real Name
    Patrick Pierre-Jerome
    Join Date
    Feb 2004
    Location
    New Jersey
    Posts
    139

    Default Odd function grouping

    Hello Tom,
    I did not think to use the help system to find the "CDOW()" function. You are right about the explanation being very complete.
    The place where I had difficulty finding the function was elsewhere. While in the expression builder, I pressed F4 on my keyboard which brought up the function finder dialog box. From the "select a category" drop-down list, I selected "date". CDOW() was not in the resulting list. Instead, it shows up in the list when I choose "character" from the drop-down list. Like Stan said in his post above, "Takes getting used to, I suppose".
    There is no love sincerer than the love of food.
    George Bernard Shaw

  7. #7
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,307

    Default

    Patrick, the "Alpha Five Help" (CHM version) is often kept open in a separate window for quick reference by many of us. If you're not using it you're working too hard. It's a wonderful resource. -- t

Similar Threads

  1. help with extracting data
    By lmarini in forum Alpha Five Version 7
    Replies: 9
    Last Post: 11-19-2005, 07:43 AM
  2. Extracting strings from a Variable
    By John Castle in forum Alpha Five Version 5
    Replies: 10
    Last Post: 09-16-2005, 08:21 AM
  3. Extracting highest value
    By Caroline Baker in forum Alpha Five Version 6
    Replies: 2
    Last Post: 02-26-2005, 01:20 AM
  4. Calendar Day View - Day Wrong
    By scottly in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-05-2004, 02:18 PM
  5. Extracting same info from 2 tables
    By Norm Neault in forum Alpha Five Version 4
    Replies: 2
    Last Post: 11-20-2001, 05:55 PM

Bookmarks

Posting Permissions

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