0

monthName Format

Hi

 

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

 

Any tips?

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Lars
    • Lars
    • 4 mths ago
    • Reported - view

    Hi Simon,

    what about

    substring(monthName(yourDate), 0, 3);
    Like
  • Hi Simon,

    You can use

    format('Date Field',"MMM")

    Like 1
      • Lars
      • Lars
      • 4 mths 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.

      Like 1
    • UweG
    • UweG
    • 4 mths ago
    • Reported - view

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

    Like
Like Follow
  • 4 mths agoLast active
  • 4Replies
  • 28Views
  • 4 Following