How to format Date[N] in screener results

• 05/25/2021 at 10:08 AM #170324
  HansLatour

  How can I format the Date[N] variable in a column of the screener.
  It ‘translates’ YYYYMMDD’ to a numeric value.

  

  HansLatour

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 1 time
  05/25/2021 at 11:08 AM #170340
  robertogozzi

  IT IS a numeric value. ProRealTime only supports floating point numeric data,

  A date is usually displayed, with DrawText, as 20M (20 million).

  You can try to remove the two leftmost digits (20), with this trick, so that 20210526 is abridged to 210526, but it will be reported with the thousands separator and, for years 0 to 9 the leading 0’s will be dropped (not tested):

  x = round((date / 1000000) - 0.5) y = x * 1000000 MyDate = date - y

  1 2 3

  x      = round((date / 1000000) - 0.5) y      = x * 1000000 MyDate = date - y

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17659

  Been thanked: 4367 times
  05/25/2021 at 12:10 PM #170361
  HansLatour

  Hi Roberto, thanks for your solution, works great!

  I created a millennium-bug by taking a shortcut to your code by just subtracting 20000000 🙂

  1 user thanked author for this post.

  robertogozzi

  

  HansLatour

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 1 time
• Author
  Posts