How to convert string to date?

Andrew2009

Well Known Member
I read from a csv file and there's a date value in it. I read it out as a String. I want to assign it to a date variable (alias is DGJ). How do I do that in JDE 9.1 please?
 
Andrew,

Do you have Patwel's (Craig_Welton) JDE ObjectBrowser? I recommend it (http://www.patwel.com).

You can use it to search for Business Functions and test there functionality. When I'm look for certain functionality I use ObjectBrowser every time.

Here are 4 business functions that I found using ObjectBrowser that convert a string to a date:

B0800013 - Convert String to Date
N0800640 - Convert String to Date
B74I0010 - Convert String to Date Format Mask - 00
B0800208 - Convert Status Change Date String to Date Format
 
You can use B0800208 - Convert String to Date Mask as said peterbruce, you map input string date, format mask and return jde date.

Regards.
 
// CCA - Assuming you have a date DD/MM/YYYY
B74I0010 Convert String to Date Using Format Mask
VA rpt_DateJDE_TRDJ <- ConvertedDate
VA evt_StringDate_AA10 -> StringToConvert
"D/M/E" -> FormatMask
 
Back
Top