fpineda101
Well-known member
I am trying to create an ATM system that gets the last 5 transactions and displays them. I am using Oracle as the DB. This is the code I have...
--------------------------------------------------------------------
SQL = "SELECT * FROM transaction WHERE account_number = '" & ca.SecondAccountNum & "' ORDER BY trans_date DESC"
ExecuteSQL(SQL)
For i = 0 To 4 'last five transactionsS
statementScreen += " Account: " & rs.Fields(0).Value & " "
statementScreen += " Date: " & rs.Fields(1).Value & " "
statementScreen += " Amount: " & rs.Fields(2).Value & newLine & newLine
rs.MoveNext()
Next
---------------------------------------------------------------------
The string appears like this...
Account: 22222 Date: 12/14/2005 5:30:28 PM Amount: -49.00
I would like to know how to format the date as 14-Dec-2005 or December 14, 2005. Thanks in advance for your help....
--------------------------------------------------------------------
SQL = "SELECT * FROM transaction WHERE account_number = '" & ca.SecondAccountNum & "' ORDER BY trans_date DESC"
ExecuteSQL(SQL)
For i = 0 To 4 'last five transactionsS
statementScreen += " Account: " & rs.Fields(0).Value & " "
statementScreen += " Date: " & rs.Fields(1).Value & " "
statementScreen += " Amount: " & rs.Fields(2).Value & newLine & newLine
rs.MoveNext()
Next
---------------------------------------------------------------------
The string appears like this...
Account: 22222 Date: 12/14/2005 5:30:28 PM Amount: -49.00
I would like to know how to format the date as 14-Dec-2005 or December 14, 2005. Thanks in advance for your help....