Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > Include server date in web part "Where Condition" View modes: 
User avatar
Member
Member
wukimus-hotmail - 8/7/2013 11:00:00 AM
   
Include server date in web part "Where Condition"
Hi all,

How do I add a condition that includes the server date in the where condition section of a web part e.g

EventSection LIKE '%National%' OR EventSection LIKE '%Region 4%' AND EventDate >= Serverdate

Thanks in advance

User avatar
Certified Developer 13
Certified Developer 13
kentico-jx2tech - 8/7/2013 11:24:47 AM
   
RE:Include server date in web part "Where Condition"
try using GETDATE()

http://technet.microsoft.com/en-us/library/ms188383.aspx

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 8/7/2013 12:09:45 PM
   
RE:Include server date in web part "Where Condition"
Hello,

You can also try a CURRENT_TIMESTAMP function.

For more details take a look at the following articles:
1. Date and Time Data Types and Functions - SQL Server
2. Getting current system time in SQL Server

Best Regards,
Martin Danko

Top