Question

8
Replies
13579
Views
 Sumit Verma (SumitV24)
Amazon

Amazon
US
SumitV24 Member since 2015 23 posts
Amazon
Posted: October 14, 2015
Last activity: September 12, 2017
Posted: 14 Oct 2015 9:58 EDT
Last activity: 12 Sep 2017 21:19 EDT
Closed
Solved

Is there any OOTB function available to get the month name from current date?

Example - If I use this function today; it should give October
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.
Posted: 5 years ago
Posted: 14 Oct 2015 10:21 EDT
Gowrishankar Ramasamy (GOWRISHANKAR)
PEGA
Sr. Service Assurance Advisor Specialist
Pegasystems Inc.
IN

Hi Sumit,

           There is an OTTB function "@DateTime.month(pegaRulesDate)" , this will return the numeric values between '0 to 11' . here 0 indicate 'January', etc..

You can create decision rule to set the string values appropriately.

here pegaRulesDate value for today is 20151014 (yyyymmdd)

Please let me know if this helps,

Thanks,

Gowrishankar.
Posted: 5 years ago
Posted: 14 Oct 2015 10:25 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

The same applies to SQL functions if you are referring to report definitions. pxMonthNumber function will give you the number and you can use a control to show the right name based on the number.
Posted: 5 years ago
Posted: 14 Oct 2015 10:28 EDT
Brendan Horan (BrendanHoran_GCS)
MOD
Technical Director, Global Client Support
Pegasystems Inc.
US

Oh nice! Or just use that control that Rajiv just mentioned. Even better

Thanks.

B.
Posted: 3 years ago
Posted: 11 Sep 2017 10:47 EDT
Naresh RP (NareshRP)
Virtusa

Virtusa
IN

To see the months in Report you need to write the source with custom Function alias like pxMonthNumber with "Text" return type.


<p:choose>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATE'">


    (CASE WHEN {1} IS NOT NULL


       THEN


       SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+' '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)         


    END)  


</p:when>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATETIME'">


     <p:choose>


         <p:when test=".pyParameters(1).pyDBDataType == 'DATETIME'">


 


     SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+', '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)         


         </p:when>


<p:otherwise>


(CASE WHEN {1} IS NOT NULL 


          THEN SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+' '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)


          END)


</p:otherwise>


     </p:choose>


</p:when>


</p:choose>
Posted: 3 years ago
Posted: 12 Sep 2017 21:19 EDT
Naresh RP (NareshRP)
Virtusa

Virtusa
IN

To display Quarterly like Jan-Mar, 2017 or Apr-Jun, 2017, we can add new Function  alias as below, with return type "Text",


 

Show More

To display Quarterly like Jan-Mar, 2017 or Apr-Jun, 2017, we can add new Function  alias as below, with return type "Text",


 


<p:choose>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATE'">


    (CASE WHEN {1} IS NOT NULL


       THEN


        SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)        


    END)  


</p:when>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATETIME'">


     <p:choose>


         <p:when test=".pyParameters(1).pyDBDataType == 'DATETIME'">


 


      SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)            


         </p:when>


<p:otherwise>


(CASE WHEN {1} IS NOT NULL 


          THEN  SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)    


          END)


</p:otherwise>


     </p:choose>


</p:when>


</p:choose>



Show Less
Posted: 5 years ago
Posted: 14 Oct 2015 10:27 EDT
Brendan Horan (BrendanHoran_GCS)
MOD
Technical Director, Global Client Support
Pegasystems Inc.
US

Adding to the previous response, I think the combination of functions will get you what you need.

@DateTime.month(@DateTime.dateValue(@DateTime.getCurrentDateStamp()))

As mentioned, the function will return an integer. So if you want to actually have the text date set on the property, you'd have to write something like a very simple data transform to set the text based on the value returned.

Thanks.

B.

Accepted Solution

Posted: 5 years ago
Posted: 14 Oct 2015 12:06 EDT
Pankaj Rawal (rawap)
PEGA
Sr Architect, Case Management
Pegasystems Inc.
IN

@(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "MMMMM", "", "")

This should give you "October'
Posted: 4 years ago
Posted: 22 Aug 2016 5:48 EDT
Bjorn Podlaha (bpodlaha76)
Capgemini Deutschland GmbH
Principal Business Analyst and PEGA CSSA
Capgemini Deutschland GmbH
DE

Hint: if your dates are configured as "Date only" properties you must add the term "T000000.000 GMT" to work the function as described above.


Example:


Set. ContractStartMonth equal to (@DateTime.FormatDateTime(.ContractStartDate + "T000000.000 GMT", “MMMMM”, “”,””)

Related content:

Question

Is there any function available in pega to return the day name for a given date?

Question

Is there any function available in pega to return the day name for a given date?

Question

Is there any function available in pega to return the day name for a given date?

Question

Is there any function available in pega to get Week number from given date?

Discussion

How to get current date?

Question

Is there OOTB function(s) to get difference between two dates in months and dates?

Question

How to Split date from current System date?

Question Solved

Is there any Pega OOTB function available to Strip the Invalid Characters from String ?

Discussion

Is there any OOTB functionality available in PEGA for exchanging the file between the current and the external application?

Question

Is there any OOTB Pega function to convert any valid date to MM/DD/YYY