-1

Date format in Table Builder

Jet Reports Historic Posts

June 14, 2016 06:05

None

Follow

This works perfectly.

Many thanks!

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts June 15, 2016 20:17 Official comment

  Hi -
  
  Give this a try…
  
  =NP("Formula","=TEXT(EOMONTH([@[Posting Date]],0),""mmm yyy"")")

• 0
  
  Jet Reports Historic Posts June 14, 2016 06:05

  Hi - I need to set the format of a date field in a Jet table.
  
  I want to show the end of month date for the posting date, and format this as MMM YYY
  Pretty sure it should be something along these lines below - however I keep getting errors. I think I may even just be missing a couple of brackets perhaps?
  
  Any help with syntax would be appreciated
  
  =NP("Formula","=TEXT(EOMONTH([@[Posting Date]],0)),("mmm yyy")")
  
  Cheers