Question
2
Replies
120
Views
Posted: July 25, 2017
Last activity: July 25, 2017
Closed
Is it possible to user functions inside a Connect-SQL rule
Hi,
I have a requirement to use Connect-SQL rule. I have to fetch the records which are resolved today. I am planning write a query using pyResolvedTimeStamp and pxCurrentDateTime. I need only the date and year part of these two properties.(Time is not required). For this is it possible to use functions in Connect-SQL query.
Thanks in advance.
Regards,
Manasa
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
I've seen it many times in select and from clauses. I suspect you can also do it inside a DECLARE BEGIN END in the Obj-Save of a Connect-SQL as stored procedures are often configured.