Solved

Count incoming Emails

Posted on 2003-11-21
14
431 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes email code 6 122
Lotes Notes 8.5.3 std can not open calendar 2 119
IBM Domino web server 5 71
Outlook Contact Export as .msg trying to import in Lotus Notes 5 116
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…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 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