This formula works perfect with one exception for my situation.   When used where there are nulls, it fails.   I'm trying to convert a Number to date "20101108".

The report refreshes, however once I try to page through it or export... it pulls up the Formula Editor and states "Bad date format string". 

date(left(totext({ORDMST.OMRDAT},0,""),4)+"," + mid(totext({ORDMST.OMRDAT},0,""),5,2) +"," + right(totext({ORDMST.OMRDAT},0,""),2))

I'm looking for some help on how to handle null (blank)

Thanks for the quick reply, thanks.

Simple answer [blank or 'na' ]would be fine. 

Current date would work as well.

returns "Bad date format string" error.

I see it is numeric but you just want a string of 'YYYYMMDD'?