Hi Reg SAP GUIXT

[Former Member]

Hi All,

In Guixt I want to Add a TextBox. In that, my requirement is to fill the textbox with date and save it.

I want to know whether the date will be saved into the database table or not.

I want to update that date into database table for particular sales order.

Is it possible by Guixt if not Please help me with the suitable way to solve it.

Thanks & Regards,

Vijay.

[Former Member · Accepted solution]

Hi Vijay,

if you are tring to create a Datefield and want to extract the data check this.

http://www.synactive.com/tutor_e/lessonia05.html

to obtain the day, month and year from a date field:-

Set V[date] "20.02.2003"

Set V[day] "&V[date](1-2)"

Set V[month] "&V[date](4-5)"

Set V[year] "&V[date](7-10)"

In order to make this work for every date representation in SAP, use the following coding:

V[date] is a valid SAP date.

Set V[DateTest] &V[date](5-5)

if V[DateTest=.] or V[DateTest=-] or V[DateTest=/]

Set V[year] &V[date](1-4)

Set V[month] &V[date](6-7)

Set V[day] &V[date](9-10)

else

Set V[year] &V[date](7-10)

Set V[DateTest] &V[date](3-3)

if V[DateTest=.]

Set V[month] &V[date](4-5)

Set V[day] &V[date](1-2)

else

Set V[month] &V[date](1-2)

Set V[day] &V[date](4-5)

endif

endif

[Former Member]

Hi,

Thanks for the reply.

In Production Order(Order No.6001234), By using GUI XT concept, I added textbox and given date value and saved it.

I am able to see the same date value for other production orders too.

My requirement is to get date values for production orders depending upon the user entry in the text box not to reflect the same date value for all the production orders.

Moreover, I am not saving the values in the database. Just for the user information I am providing the values on the screen itself.

So How to handle or get the indivdual date values for each and every production order.

If my question was not clear, Please give me your contact number.So that I will contact you.

U can mail me @ varma_belamkonda@yahoo.com

So Please help me out in this as it is a burning issue for us.

Thanks and Regards

Vijay