0

Adding Formula to convert Date in Table Builder

Jet Reports Historic Posts

September 17, 2015 07:06

None

Follow

Hello,

I'm wondering how I can add a Formula in my table builder to convert a date in my report so that it only shows the Month name. Eg. 01/01/2015 …using the excel way, changing the format to 'mmmmm' to display the month. Just need to know how to do it in Table Builder

thanks :)

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts September 17, 2015 15:33 Official comment

  You won't be able to hide the date you want but you can build a formula against it. See my screenshot:

  • date-table-builder.png
• 0
  
  Jet Reports Historic Posts September 17, 2015 23:00

  That's great, thank you.

• 0
  
  Jet Reports Historic Posts October 08, 2015 12:25

  in order to same report, How to build formula for "Sept-15"
  
  thank you in advance

• 0
  
  Jet Reports Historic Posts October 08, 2015 12:37

  The syntax you would use in your TEXT() function would be:
  
  Text([@[Posting Date]],"Mmm-DD")

• 0
  
  Jet Reports Historic Posts October 09, 2015 04:18

  it's working. thank you