Powerbuilder/SQL on Windows XP: date becomes ‘1900-01-01’
Asked By
0 points
N/A
Posted on - 01/22/2013
Good day!
I have a program built using Powerbuilder and uses MS SQL as its database, running on windows XP OS. I have a window that works as a date prompt. This window serves as an interface for the user to enter the date range of the report to be generated. It was working for about 3 months but just the other day it stopped functioning. I tried to use a message prompt to see if it is getting the correct date, on powerbuilder the correct date is being shown. But once it has been processed on the SQL side, the date becomes '1900-01-01'. Below are some of the codes:
"open(w_date_prompt_with_time)
ls_msg = Message.StringParm
If IsNull(ls_msg) Then Return -1
li_tab = Pos(ls_msg, ";", 1)
ls_dateTimefrom = left(ls_msg,li_tab – 1 )
ls_dateTimeto = right(ls_msg,li_tab – 1 )
li_tab = POS(ls_dateTimefrom, " ", 1)
ldt_from = DATETIME( DATE(left(ls_dateTimefrom, li_tab – 1)),TIME(Right(ls_dateTimefrom, 5 )))
ldt_to = DATETIME( DATE(left(ls_dateTimeto, li_tab – 1)),TIME(Right(ls_dateTimeto, 5 )))
//ib_get_all = false
li_count=dw_rowmanager.Retrieve(ldt_from,ldt_to)"
Â
Thanks in advance.
