Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListFilter by DAY of weekFilter by DAY of week
Previous
 
Next
New Post
1/7/2009 11:21 AM
 
How might I filter by DAY of the week (not DATE) and on top of that filter inside a START TIME and END TIME window? I've got the START TIME and END TIME figured out, but how do I combine that filter with a DAY of the week?
 
New Post
1/7/2009 11:58 AM
 

It's a bit tricky but you can do it.

1. Add new column called "DAY of the week"

2. Select  RichText(html) as type

Now, pick one row you want to edit. On the Day of the week field, switch to "Source" mode. You would want to enter the html directly. Click "Source" button left upper-corner of Rich Text Editor.

Then enter following code (Obviously, you need to pick one line from following.)

<INPUT type=hidden name=Day0>Sunday
<INPUT type=hidden name=Day1>Monday
<INPUT type=hidden name=Day2>Tuesday
<INPUT type=hidden name=Day3>Wednesday
<INPUT type=hidden name=Day4>Thursday
<INPUT type=hidden name=Day5>Friday
<INPUT type=hidden name=Day6>Saturday

On the list, users don't see the tag because it's hidden tag. However, the program reads it and use it to make orders. The text on "Day of the week" doesn't have any sorts of order information so we need to give it to them as Day0, Day1, Day 2 and such. If you want to make it start from Monday, Just change the number on hidden tag.

 
New Post
1/7/2009 1:42 PM
 

Create a Column aDate, Datatype Date, formatexpression "dddd". The datagrid will render that column now to Monday, Tuesday, ...
You can filter for the day of the week using [aDate_UDT_Value]='Monday'

If you want to show only the real date, hide the column aDate and add a second column theDayToShow, type calulated column, expression [aDate] and the format string you want.
  

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListFilter by DAY of weekFilter by DAY of week


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out