Skip to main content
Topics#Ask An ExpertDomanda di AMAN RANA
AMAN RANA (Always a Learner) ha fatto una domanda in #Ask An Expert
16 apr 2019, 08:27

I 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 risposte
  1. Amnon Kruvi (The Architech Club)
    16 apr 2019, 10:39
    Oh, 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())
Scrivi una risposta...
0/9000