Sharepoint Answers

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds
  Question Asked By: Chandrak Mane   on Dec 22, 2009 In Sharepoint Category.

 
Question Answered By: Akshara Sanghavi   on Dec 22, 2009

You will have to use the Filters in the listview and with the date  Column you will have to write a formula and use the Filter with an AND/OR condition. Basically you will have to use:

Greater than or Equal To and
Less than or Equal To.

with the same DATE COLUMN.

Now in the value Filter condition column  write the formula using the DATE FUNCTIONS listed in the following link on the same date column. We know each month  starts with 1 as 1st day but we need the month and year also, for end of the month day you will have to use EOMONTH and MONTH functions. This is a little complex functions to write but this post should get you started on writing the function: blog.ray1.net/.../...culated-fields-use-excel.html%20and%20Time%20functions

For Date functions check this article:
office.microsoft.com/.../HP100622881033.aspx

Tagged:              

 
 
Didn't find what you were looking for? Find more on Filtering a list view for a specific date range.. Or get search suggestion and latest updates.