adding plsql code to where clause

Posts   
 
    
buckd32
User
Posts: 20
Joined: 09-Oct-2009
# Posted on: 14-Oct-2009 11:31:22   

how would i go about adding this to check to see if any dates are three days over due

i use the llbgen datasource 2 to fill my radgrid and need to filter overdue returns of three days for sabbaticals

how do i add this code : to the data source

[expire_date] >=trunc(sysdate)-3

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 14-Oct-2009 16:38:05   

Do you have to use the database sysDate, or you may use the .NET DateTime.Now? Database date vs Server date?