Hi All,
I have a field Year-Month, as 201408 . I am using Qaaws to bring to Dashboard.
Once this is mapped to excel sheet , I tried to change format by:
- Cell A1 has value : 201408
- Added a date to Year and Month as: 201408&10
- This turned it to: 20140810
- Then in next cell A2, I used formula: TEXT(A1,“0000-00-00”)
- Now A2 looks like : 2014-08-10
- In Cell A3 I used Formula: ValueDate(A2)
- Result is a Date :08-01-2014
However when mapped to a spreadsheet table, on Going for Preview, I see all formulas gone and cell A3 showing #VALUE error, while A2 shows 20140810 .
All formulas lost in turning to swf file.
Please advise on how to resolve this??
Need Help… 
americanmc 
(BOB member since 2009-12-31)