Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from SGB on Feb 4 at 12:13 PM Hi Doug, forgot to mention, without the cmod code and date formula variable, if i use the same date format in the query, it works all fine.
| | | ---------------Original Message---------------
From: SGB
Sent: Tuesday, February 04, 2014 11:29 AM
Subject: Date Converted to Numeric in BEX Issue
Hi Experts,
I've created a formula variable on NETDUEDATE and via cmod (and other logical calculation) I need to fill the next corresponding date. I can successfully see that the date is correctly populating at BW side (i could check this when debugging - the date populated is 02/04/2014 in mm/dd/yyyy format.
But while i run the query (via rsrt/bex query designer), i see that the date field is populated as 20,140,204.0000000.
Could you please suggest how to convert it to the correct date format with steps. Need this help urgently.
Thanks so much for your time and patience.
BR, sap |
| Reply to this email to post your response. __.____._ |   _.____.__ |
