Skip to Content
0
Former Member
May 14, 2008 at 02:00 PM

Replacement Path for Date

60 Views

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.