0

monthName Format

Hi

 

I would like to return "Jan" instead of January when using the "monthName" function. 

 

Any tips?

4 replies

null
    • Lars
    • 2 yrs ago
    • Reported - view

    Hi Simon,

    what about 

    substring(monthName(yourDate), 0, 3);
    • Danjamesmedia
    • 2 yrs ago
    • Reported - view

    Hi Simon,

    You can use

    format('Date Field',"MMM")

      • Lars
      • 2 yrs ago
      • Reported - view

      Dan James (Ninox Partner)  I was sure there was something like this, but didn't find it. Thanks for pointing that out.

    • UweG
    • 2 yrs ago
    • Reported - view

    Maybe the Ninox Reference DB in the German webinar team can be helpful in the future.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 43Views
  • 4 Following