Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date help

Status
Not open for further replies.
dvraggs

dvraggs

Technical User
Jan 30, 2002
22
0
0
US
What I want is find out what day something happen on. Example: Date of transaction 07/15/2002. I need to know if that is a Monday, if so turn row red in table. If anyone has any idea how to do this please help.

Thank you,
Dvraggs
 
Sort by date Sort by votes
Use DayName()function to figure out the day. Use alerter to change the color of the row.
Hope this helps.
 
Upvote 0 Downvote
The database was not a date it was a string. I hade to use ToDate first then DayName.
Thank you,
Dvraggs
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Clappy2000
  • Locked
  • Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
102
Clappy2000
Clappy2000
Emmy2368
  • Locked
  • Question
Creating Year to Date Filter
Replies
4
Views
97
Emmy2368
Emmy2368
t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
85
hilfy
hilfy
PWD
  • Locked
  • Question
Year([Arrival Date]) Produces 2,015
Replies
4
Views
82
hilfy
hilfy
PWD
  • Locked
  • Question
Filtering BO Report <= Date
Replies
3
Views
33
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top