0

Filtered Date format

Jet Reports Historic Posts

February 12, 2013 08:41

None

Follow

Does anyone knows how to change the format of the filtered date?
See attached file for the sample

• sample.xlsx

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts February 12, 2013 09:55 Official comment

  Since $D$3 is no longer a date field, I'd refer to $C$2.
  Does this work for you? ="LAST YR. " & NP("format";$C$2;"mmm 'yy")
  P.s. Beware that Sheet2!B1 will become Sheet2!C2 if you run the report as Jet will claim Column A / Row 1 with Auto+Hide. So, you need to change the reference in Sheet1!$C$2.

• 0
  
  Jet Reports Historic Posts February 12, 2013 10:13

  So..in short, I really cannot change ..1/31/2013 into the format I wanted?

• 0
  
  Jet Reports Historic Posts February 12, 2013 10:18

  Since $D$3 is no longer a date field, I'd refer to $C$2.
  Does this work for you? ="LAST YR. " & NP("format";$C$2;"mmm 'yy")
  P.s. Beware that Sheet2!B1 will become Sheet2!C2 if you run the report as Jet will claim Column A / Row 1 with Auto+Hide. So, you need to change the reference in Sheet1!$C$2.

  
  
  Correction with the code:
  
  Should be ="LAST YR. " & NP("format",$C$2,"mmm 'yy")
  I already tried this and it worked fine. But I hope I will get a clear answer about the changed format for ..01/01/2012 to jan '12
  
  ;)
• 0
  
  Jet Reports Historic Posts February 12, 2013 10:40

  In our country we use ; as symbol between Excel arguments instead of ,.
  My bad, I wasn't paying attention to your settings.
  
  You want to format a date. The datefilter you create in D3 is not a date, therefore the change to C2.

• 0
  
  Jet Reports Historic Posts February 13, 2013 02:07

  Thank you ;)