Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
2724 day(s) ago   #94
Name: Cloud
Category: Technical
Location: India
Date: 2012-12-14 20:00:03
Replies(3)

Status:
  #94

Using date format in conversion from string to date

Here is a quick and simple example of how to use the date format string to convert a string to a date. This helps to avoid parsing the string manually. In this example I am using "OAE" to decode the date string. The business function is B74I0010.

VA evt_DateStr_DSC1 = "08062011"
Convert String to Date Using Format Mask
VA evt_DateValue_DATE01 <- BF ConvertedDate
VA evt_DateStr_DSC1 -> BF StringToConvert
"OAE" -> BF FormatMask
VA evt_DateInvoice_DIVJ = VA evt_DateValue_DATE01

Cheers
JDE Techno-Functional.
2718 day(s) ago   #95
Name: Alex
Category: Technical
Location: India
Date: 2012-12-20 01:40:07
Replies(3)

Status:
  #95

Using date format in conversion from string to date

Hi Cloud, This business funcion will return the date in which format, please specify which format mask is used for which format type.

Regards
Alex
JDE E1
1864 day(s) ago   #178
Name: gugu
Category: Technical
Location:
Date: 2015-04-23 03:59:49
Replies(3)

Status:
  #178

Using date format in conversion from string to date

converting date to a string e.g 23 April 2015 in JDE
1852 day(s) ago   #180
Name: Nicky
Category: Technical
Location: India
Date: 2015-05-05 20:35:47
Replies(3)

Status:
  #180

Using date format in conversion from string to date

Hi Alex,

An explanation of what each letter means in Format Mask is explained below.

Format Masks
D - Day Number, 1 or 2 digits
A - Day Number, zero padded to two digits
Y - Day Number, space padded to 2 digits
M - Month Number, 1 or 2 digits
O - Month Number, zero padded to 2 digits
N - Month Number, space padded to 2 digits
T - Month Number, by language from UDC
B - Abbreviated Month Name, by language from UDC
R - 2 digit Year
E - 4 digit Year
S - Date slash / character as separator
C - Date comma , character as separator

Next, the business function "N3401570 - Convert Date to Julian Format" can be called to convert the Date obtained in the first business function above to the desired Julian Date format.

Please refer to Oracle doc How to Convert a String to a Julian Date (Doc ID 660527.1) for more details.

Cheers!!
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in