Question

2
Replies
132
Views
Manasa Chidirala (ManasaCh)
HCL
Senior Consultant
HCL
IN
ManasaCh Member since 2014 3 posts
HCL
Posted: July 25, 2017
Last activity: July 25, 2017
Posted: 25 Jul 2017 7:44 EDT
Last activity: 25 Jul 2017 8:03 EDT
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

Low-Code App Development
Moderation Team has archived post, 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.