Hi, i am trying to write a filter that ll get me the list of users whose birthday is this week (between today and 7 days from today).

the entity is user and the field is birthday.

i dont know how to use dayofyear with userfields.birthday.

any ideas? thanks

-shane

What would you do in sql? For instance, if you are looking for this:

SELECT * 
FROM Users
WHERE Birthday BETWEEN GETDATE() AND DATEADD(dd, 7,  GETDATE())

then this is an approximate code (assuming Adapter):

UserCollection users= new UserCollection();

IExpression funcGetDate = new DbFunctionCall("GETDATE", new object[] {});
IExpression funcDateAdded = new DbFunctionCall("DATEADD(dd, 7, {0})", new object[] {funcGetDate});

IPredicateExpression filter = new PredicateExpression(
    new FieldBetweenPredicate(UserFields.Birthday,
           UserFields.Birthday.SetExpression(funcGetDate), 
           UserFields.Birthday.SetExpression(funcDateAdded)));

users.GetMulti(filter);

David, thanks for the answer but birthdate can not be between todays date and 7 days from now. i know i have to use dayofyear but i dont know how to use it as a predicate expression.

using self servicing.

-shane

i am trying to write a filter that ll get me the list of users whose birthday is this week (between today and 7 days from today).

Are you working in Facebook

the entity is user and the field is birthday. i dont know how to use dayofyear with userfields.birthday.

Do you know the SQL statement you ned to execute? If so would you please post it here.

Walaa wrote:

i am trying to write a filter that ll get me the list of users whose birthday is this week (between today and 7 days from today).

Are you working in Facebook

no, not in facebook it is an application to track student birthdays.

the entity is user and the field is birthday. i dont know how to use dayofyear with userfields.birthday.

Do you know the SQL statement you ned to execute? If so would you please post it here.

i guess it ll be something like:

datepart(dy,BirthDate) between datepart(dy,GETDATE()) and datepart(dy,GETDATE()) + 7

-shane

This is easier done with Linq (if it's an option). If so, please check the following thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16737

Walaa wrote:

This is easier done with Linq (if it's an option). If so, please check the following thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16737

unfortunately i dont use linq yet.

e106199 wrote:

David, thanks for the answer but birthdate can not be between todays date and 7 days from now. i know i have to use dayofyear but i dont know how to use it as a predicate expression.

I thought it should work that way Anyway, here you go with an approximate code for what you are looking for (without linq):

UserCollection users = new UserColletions();

IExpression funcGetDate = new DbFunctionCall("GETDATE", new object[] {});
IExpression betweenStart = new DbFunctionCall("DATEPART(dy, {0})", new object[] {funcGetDate});
IExpression betweenEnd =  new Expression(betweenStart, ExOp.Add, 7);
EntityField2 betweenLeftOp = UserFields.BirthDate.SetExpression(
    new DbFunctionCall("DATEPART(dy, {0})", new object[] {UserFields.BirthDate}));

IPredicateExpression filter = new PredicateExpression(
    betweenLeftOp >= betweenStart & betweenLeftOp <= betweenEnd );

users.GetMulti(filter);

decided on using a computed field that will return 0 or 1 depending on the match.

way easier that way

thanks -shane