Format Number Question

[#1]

Hello - I'm unable to format a number in to the this layout: 05-14-2015

The below format is not working '##,##,####' as it displays the value as : 05,14,2015

Can anyone help?

NUM(SUM({<PI_ID={'DATE'}>} VALUE), '##,##,####'),

[swuehl · Accepted solution]

Try,

NUM(SUM({<PI_ID={'DATE'}>} VALUE), '##-##-####','.','-'),

[#3]

Hi that didn't work

[swuehl]

Seems to work for me. If you want a leading zero:

=NUM( 5142015, '00-00-0000','.','-')

[#5]

I see now it is working. thank you!