How are FORMAT column options used with the SCREENER function ?

• 11/17/2021 at 10:46 AM #181729
  bobt

  Hi,

  I’m doing some work with a screener where I’d ideally like to output text instead of simply returning a number ( from documentation I believe only numbers can be displayed in columns returned by screeners).

  However, looking at the function list, when looking up “SCREENER”, I also see DATEFORMAT, NUMBERFORMAT, PERCENTFORMAT and STRINGFORMAT options that can be used for displaying column results.

   

  I can’t find these options documented  – are they new ? How are they used ? and do they hint at move to being able to display text in columns returned by SCREENER ?

  Grateful for any info you can provide ……

  

  bobt

  Participant

  Topics: 10

  Replies: 11

  Been thanked: 1 time
  11/23/2021 at 7:15 PM #182150
  robertogozzi

  I never heard about those keywords, they must be something in the pipeline that might be added in a future version.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17275

  Been thanked: 4124 times
  11/24/2021 at 9:34 AM #182188
  bobt

  Roberto,

   

  Many thanks for the reply.

  OK, I’ll just have to keep an eye on new releases then – returning text would be amazingly useful for screeners ……

   

  Regards,

  Bob

  

  bobt

  Participant

  Topics: 10

  Replies: 11

  Been thanked: 1 time
  12/07/2021 at 10:45 AM #182922
  erike

  I also have the same need as Bob and saw the keyword (future). See attached file.
  Before this is implemented, is there a way to solve this by code?

  -Erik

  

  erike

  Participant

  Topics: 7

  Replies: 9

  Been thanked: 0 times
  12/07/2021 at 3:34 PM #182950
  robertogozzi

  No, a specific instruction is needed.

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17275

  Been thanked: 4124 times
  12/07/2021 at 4:35 PM #182956
  Nicolas

  Hey guys, here is how it works with this new way of displaying numbers in the sorting criteria column:

  SCREENER(DATE as “DATE” DATEFORMAT) => 10 mai 2021
  SCREENER(DATE as “DATE” STRINGFORMAT) => 20210510
  SCREENER(DATE as “DATE” NUMBERFORMAT) => 20,2M
  SCREENER(DATE as “DATE” PERCENTFORMAT) => 2021051000%

  1 user thanked author for this post.

  bobt

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  12/08/2021 at 11:10 AM #182998
  bobt

  Many thanks Nicolas, that helps clarify things – I’ll give that a try.

  

  bobt

  Participant

  Topics: 10

  Replies: 11

  Been thanked: 1 time
• Author
  Posts