himanshu Hi, I think Function that Return String as Month (JAN, FEB, MAR) like is not there in Date & Time Function List.. CURRENT_MONTH_OF_YEAR Function returns: string of month name. Require,
aware_support Aware IM uses Java notation for displaying date format. You can look up Appendix C of the User Guide or Google for "SimpleDateFormat Java". There is a detailed description of a very flexible notation.