date conversion YYYYMM to MM/DD/YYYY !!!!!!!!!!

HI,

Can anyone suggest me how to convert string YYYYMM to jdedate MM/DD/YYYY.
is there any business function to do it?

Hi.

I didn't see the day of the date that you were wanting to convert, so I assumed in my example below that it would be the 1st day of the YYYYMM. For example, 2000504 would be April 1, 2005.

Here are some business functions that may help:

evt_InputDate_AA06
evt_JDEDate_UPMJ
evt_OutputDate_AA10
evt_InputDate_AA08
0001 //
0002 // Input date is 04/2005.
0003 VA evt_InputDate_AA06 = "200504"
0005 //
0006 // Append "Day".
0007 VA evt_InputDate_AA08 = concat([VA evt_InputDate_AA06],'01')
0009 //
0010 // Convert Input Date (20050401) to JDE Date.
0011 Convert String to Date Using Format Mask
VA evt_JDEDate_UPMJ <- ConvertedDate
VA evt_InputDate_AA08 -> StringToConvert
"EOA" -> FormatMask
0013 //
0014 // Convert JDE date to String 04/01/2005
0015 Edit Date to String
VA evt_JDEDate_UPMJ -> jdDate
VA evt_OutputDate_AA10 <- szString
UNDEFINED -> cSuppressErrorMessage
UNDEFINED <- szErrorMessage
0013 //
0017 M & D Debug Function
UNDEFINED X szComment
VA evt_InputDate_AA06 <> szString_1
VA evt_InputDate_AA08 <> szString_2
VA evt_OutputDate_AA10 <> szString_3
UNDEFINED X szString_4
UNDEFINED X szString_5
UNDEFINED X mnMathNumeric_1
UNDEFINED X mnMathNumeric_2
UNDEFINED X mnMathNumeric_3
UNDEFINED X mnMathNumeric_4
UNDEFINED X mnMathNumeric_5
UNDEFINED X cCharacter_1
UNDEFINED X cCharacter_2
UNDEFINED X cCharacter_3
UNDEFINED X cCharacter_4
UNDEFINED X cCharacter_5
VA evt_JDEDate_UPMJ <> jdDate_1
UNDEFINED X jdDate_2
UNDEFINED X jdDate_3
UNDEFINED X jdDate_4
UNDEFINED X jdDate_5
UNDEFINED X idLongInt_1
UNDEFINED X idLongInt_2
UNDEFINED X nInteger01
UNDEFINED X nInteger02
UNDEFINED X nInteger03


For the Convert String to Date Using Format Mask business function, the format mask is E for Year, O for Month and A for day.

Good luck!

Roby

HI

YOUR GUESS IS CORRECT THE DATE should be always 01

but my need is for currency conversion

i need to get the exchangerates(currency conversion rate over(crr) based on Date effectivera(eft)

my input currency codes will be EUR,AUD.... AND I need to convert the ampunt always to USD

so to get thr CRR I need to pass currency code from(in my case EUR),CURRENCY CODE TO(aLWAYS usd),and the date i have(yymmdd to EFT).HERE WHERE I AM FACING THE PROBLEM.

WHEN I TRY RUNNING UR CODE THE UPMJ IS STILL SHOWING NULL

HI RWayne


Thanks very much NOW ITS WORKING,N THANKS AGAIN