Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Convert Weekday (String) Number to Weekday Name

Posted on 2003-02-25
4
Medium Priority
?
1,566 Views
Last Modified: 2007-12-19
I am creating a report from a FoxPro 2.6 DB.  The Weekday is a single number (string).

How do I return the Name of the Day in place of the numerical value?

I've tried arrays/conversions etc to no luck.

0
Comment
Question by:NSH
4 Comments
 

Accepted Solution

by:
atevans77 earned 100 total points
ID: 8020908
Try this
Format(Weekday,"dddd")
0
 

Assisted Solution

by:hessmac
hessmac earned 100 total points
ID: 8021867
Or...

Format(Weekday(Now), "dddd")
0
 
LVL 5

Expert Comment

by:Tom Knowlton
ID: 9460109
NSH:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area to do the following:


Split points between atevans77 http:#8020908 and hessmac http:#8021867


Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

knowlton
EE Cleanup Volunteer
0
 

Expert Comment

by:YensidMod
ID: 9939126
Forced Accept

Yensidmod
EE Moderator
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question