0

left pad function not working on mac os app 2.6.9

left pad function not working on mac os app 2.6.9

I get always the failure: "Field not found" (but the Field exists ...)

Example: left pad(text(month('Ticket From')), 2, 0)

I have also tried https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/left-pad-how-to-use-5d5056a5acd72035df3958ed

2 replies

null
    • Sean
    • 3 yrs ago
    • Reported - view

    Wow, 77 views and no answers? The function is lpad() not left pad().

     

    https://ninox.com/en/manual/calculations/reference-of-functions-and-language

     

    Based on what you posted, you want to add two 0's in front of the result of the month() function?

    • Sean
    • 3 yrs ago
    • Reported - view

    Who knew lpad() was such an interesting topic?!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 7355Views