HSX Forum

CelebStock and StarBonds

oops again, should that be...

Posted by: Triggered (a.k.a psisson) on Sep 21, 10:38 in response to Triggered's post Would this change the date to an ISO8601 format for sorting?

DATEVALUE(RIGHT(A3,4)&"-"&MID(A3,3&"-"&LEFT(A3,4,2)&"-")





Post a Reply

To post to the forums you must first login!


Bethlehem (BTLHM) 10000 30.00 (0.00)          Maria (MARIA) 149999 1.02 (-0.04)          Queer (QUEER) 149999 3.52 (-0.15)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Morena Baccarin (MBACC) 12191 82.03 (-1.62)          A Winter's Journey (AWNTJ) 150000 3.53 (-0.47)          J.C. Chandor (JCCHA) 24999 11.43 (-0.09)          Morena Baccarin (MBACC) 12191 82.03 (-1.62)          Kraven the Hunter H$30 Put (KRAVN.PU) 25000 2.48 (+0.48)          The Lord of the Rings: The War o (LOTR4.PU) 25000 2.46 (+0.46)          Morena Baccarin (MBACC) 18 82.03 (-1.62)          The Lord of the Rings: The War o (LOTR4.CA) 25000 1.92 (-0.08)          Frank Grillo (FGRIL) 24999 44.38 (+0.16)          Kraven the Hunter H$30 Call (KRAVN.CA) 25000 2.18 (+0.18)          Morena Baccarin (MBACC) 18 82.03 (-1.62)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Mufasa: The Lion King (LION2) 150000 281.10 (-8.65)          Wicked Part 2 (WCKD2) 150000 224.33 (+3.30)          Mufasa: The Lion King (LION2) 150000 281.10 (-8.65)          Dan Da Dan (DDDAN) 602 1.81 (-0.05)          Jason Schwartzman (JSCHW) 1 88.28 (0.00)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Easy's Waltz (EWLTZ) 6000 9.08 (-0.05)          Dan Da Dan (DDDAN) 149342 1.81 (-0.05)          Super/Man: The Christopher Reeve (STCRS) 149999 1.84 (+0.01)          Easy's Waltz (EWLTZ) 45000 9.08 (-0.05)          Morena Baccarin (MBACC) 168 82.03 (-1.62)          Kiss of the Spider Woman (KOTSW) 2500 21.82 (-0.04)          Kiss of the Spider Woman (KOTSW) 500 21.82 (-0.04)          Christy Martin biopic (CHRSM) 750 20.25 (-0.04)          Horizon: An American Saga Chapte (HORZ2) 150000 20.10 (-0.10)          Kraven the Hunter - Opening Week (KRAVN.OW) 100000 28.79 (-1.21)          The Lord of the Rings: The War o (LOTR4) 150000 57.60 (-0.54)          The Lord of the Rings: The War o (LOTR4) 149999 57.60 (-0.54)          Gladiator II (GLAD2) 10000 166.22 (+0.63)          Gladiator II (GLAD2) 15000 166.22 (+0.63)          Evil Dead Untitled (EVLD6) 60000 29.06 (+1.80)          Scary Movie 6 (SCAR6) 150000 35.55 (+2.37)          The Beatles (BEAT1) 50000 77.88 (-3.32)          Wicked (WICKD) 150000 329.69 (+12.29)          Bethlehem (BTLHM) 1000 30.00 (0.00)          Assassination (ASSNT) 754 13.99 (-0.40)          Ariana Grande (AGRAN) 25000 93.37 (+1.25)          Ariana Grande (AGRAN) 25000 93.37 (+1.25)          See You When I See You (SYWIS) 2000 3.09 (-0.04)          Bethlehem (BTLHM) 150000 30.00 (0.00)          Kraven the Hunter H$30 Put (KRAVN.PU) 1 2.48 (+0.48)          Rebuilding (RBULD) 5000 2.07 (+0.25)