Fetching month from Date Time

Question

I'm trying to retrieve just the month from a value I have saved as a DateTime data type.

Aswini · Answer

month() ---> Returns the month from the specified date. For Example : month(datetime(2011, 12, 13, 12, 0, 0)) returns 12 month(ri!datetime) returns month(integer) Hope this helpful Regards Aswini

Shubham Aware · Answer

Hi isiomam , 
 
If you want month of particular DateTime variable you can simply use month(ri!dateTime). 
If you want current month use month(now()). 
 
Thanks, 
Shubham

khemrajs0002 · Answer

You can use the following as per your requirement:- 
 text(ri!date,"m") /*Return month in numeric format that can be either one or two digit. (Eg. "7")*/ 
 text(ri!date,"mm") /*Return month in numeric format that would two digit. (Eg. "07")*/ 
 text(ri!date,"mmm") /*Return month in text format that can would be 3 letter text. (Eg." Jan")*/ 
 text(ri!date,"mmmm") /*Return month in text format that can would be name of month. (Eg. "January")*/

aratim · Answer

You can use the function month(ri!dateTime). It will return the month from given input dateTime.

gurdeeps · Answer

Hi, Use month(now()) function, this should resolve your problem.

Venkatesh Suram · Answer

isiomam : As suggested by chandhinir , We can get the month by using month() function . 
 
month(ri!dateTime). 
 
Thanks!!