FavoriteAMAN RANA (Always a Learner) asked in #Ask An ExpertApr 16, 2019, 8:27 AMI have to show the month and year in the field and i choose the formula field and return data type is number what will be the syntax?12 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Accepted AnswerAmnon Kruvi (The Architech Club)Apr 16, 2019, 10:39 AMOh, you want today's month and year? Then we can use the TODAY() function. Let's try this: IF (MONTH(TODAY()) < 10, "0", "") + MONTH(TODAY()) + "/" + YEAR(TODAY())Add a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Accepted AnswerAmnon Kruvi (The Architech Club)Apr 16, 2019, 10:39 AMOh, you want today's month and year? Then we can use the TODAY() function. Let's try this: IF (MONTH(TODAY()) < 10, "0", "") + MONTH(TODAY()) + "/" + YEAR(TODAY())