Data filed with date format as MON 17 JAN 2012 in MY VC Table UI using SAP BPM Reporting data source

[Former Member]

Hi Expert,

I have a BPM reporting data source which is used in BPM Process in CE 7.2.

I  am trying to fetch that data which is stored during the process initiated ..My requirement is  showing data filed  with date format as MON 17 JAN 2012 in MY VC Table UI...

Please advise me how to make it possible in SP08 with CE 7.2 vesrsion..

Thanks in advance !

Best regards,

Sudhir

[former_member202465 · Accepted solution]

Hi Sudhir,

If you show the date using a Date Picker control - which is usually a must if you allow editing - you don't set it's format.

About general passing of String value representing a Date between BPM and VC see here.

One comment: Use Start / End points and not Data In / Out.

In case you map the Date field it into a String field, use something like:

=DSTR(@DATE1,"DAY DY MON YYYY")

Thanks,

Udi