Solved

Count incoming Emails

Posted on 2003-11-21
14
427 Views
Last Modified: 2013-12-18
This should be an easy Friday afternoon question, but it's driving me up the wall.

I need a view that will show me how many emails I get per day. The only problem is that when I categorize them for the count to work, it makes each email into it's own category, presumably because it's trying to use date AND time as the category rather than just date.

Help!
0
Comment
Question by:aeonflux2
  • 4
  • 4
  • 3
  • +2
14 Comments
 
LVL 2

Expert Comment

by:ksi2001
ID: 9799925

@Date(datevalue)
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9799938
In the column where you have categorized, set to show only date.. Check the column property..Date/Time tab

Also the formula should be like this

@Date(TImeDateField)


This will show only date not time

~Hemanth
0
 
LVL 2

Expert Comment

by:ksi2001
ID: 9799939

for the mail database it's

@Date(DeliveredDate)

this function strips time portion.
0
 

Author Comment

by:aeonflux2
ID: 9800468
I tried all three in the column value (formula) and they all came back saying "ERROR:Incorrect data type for operator or @Function:"

What am I doing wrong?
0
 
LVL 2

Expert Comment

by:ksi2001
ID: 9800654
hmmm. What exactly had you put in the column formula before posting here?

try this one

@Date(@If(DeliveredDate != ""; DeliveredDate; PostedDate != ""; PostedDate; @Created))
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 9801238
why can't u create a new view and have the view selection formula like this:
Select Form="Memo" & DeliveredDate=@today

Is this what ur looking for?

Do u want to apply for entire company or for u only.

U can create this view in a template.
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 500 total points
ID: 9802629
You can just use @Date(@Created) and the view selection formula as  DeliveredDate != "".. this will effectively show only the mail received
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 31

Expert Comment

by:qwaletee
ID: 9815376
,mmmmmmmmmmmmmmmm0000111     k/;;;;;;;;;;


0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9815380
scuse me... that was my one year old

Not the same qwaletee of response, I guess
0
 
LVL 2

Expert Comment

by:ksi2001
ID: 9815432
for the one year old that was high qwaletee answer ;-)
0
 

Author Comment

by:aeonflux2
ID: 9819043
Bingo! Thanks!


Qwaletee, be careful....  My 16 mth old destroyed one of our old laptops about 4 months ago by shoving it off of a table. She thinks if it's not nailed down, it's for playing.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9819118
I've lost floppy drives, CD drives, speaker systems...
0
 

Author Comment

by:aeonflux2
ID: 9819186
We finally just closed off the computer room and only use it after she goes to sleep at 7. We have so much computer junk in there, there was no way to child proof the room. :(
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9834917
Unfortunately, we have no separate computer room :(

Need larger quarters :( :(
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now