Hello Experts -
I have an infoobject called Job Complete which captures timestamps. The values look like: '01/15/2008 09:35:45'. However, I need to represent the field without the time. So it should look like '01/15/2008'.
So I created a formula variable which is using replacement path. The offset is 0 and length is 9. Its showing the number as 20,080,115. The dimension is number in the currency/unit tab.
I'm using this formula variable in a CKF.
In the formula variable in the currency/unit the dimension is 'date'. In that case, I don't see anything in my report.
Then I tried to use the formula 'Process value as date' in my CKF but still no result.
Can any one please help me with this one? I'd really appreciate it.
Thanks a lot in advance.