Android Question How to Change the Date format in a WebView

B

Brad Henderson

Member
Licensed User
Hello
I am filling a WebView with this Code:

Private Query As String = "SELECT ServiceDate, KwProduced, FedBack, PacPre, PacPost FROM Services WHERE CustomerNumber = " & MyLib.CurrentCustomer & " ORDER BY ServiceDate DESC"
wvService.LoadHtml(MyLib.ExecuteHtmlServices(Connection.GoGreenSQL, Query, Null, 0, True))

However, it displays the date in "YYYY-MM-DD" format and I would like to display as "DD-MM-YYYY"

Is this possible?
Thanks
Brad
 
Sort by date Sort by votes

mc73

Well-Known Member
Licensed User
Longtime User
You can try:
B4X: 
Private Query As String = "SELECT DATE_FORMAT(ServiceDate, "%d-%m-%Y"), KwProduced, FedBack, PacPre, PacPost FROM Services WHERE CustomerNumber = " & MyLib.CurrentCustomer & " ORDER BY ServiceDate DESC"
 
Upvote 0

mc73

Well-Known Member
Licensed User
Longtime User
Brad Henderson said:
Thanks mc73
When I try this I get an error "input string was not in a correct format".

I will look further into this option
thanks again
Click to expand...

True, my fault sorry.
Here you go:
B4X: 
Private Query As String = "SELECT DATE_FORMAT(ServiceDate, '%d-%m-%Y'), KwProduced, FedBack, PacPre, PacPost FROM Services WHERE CustomerNumber = " & MyLib.CurrentCustomer & " ORDER BY ServiceDate DESC"
 
Upvote 0
B

Brad Henderson

Member
Licensed User
Thank mc73 but this time I get this "no such function" error:

android.database.sqlite.SQLiteException: no such function: DATE_FORMAT (code 1): , while compiling: SELECT DATE_FORMAT(ServiceDate, '%d-%m-%Y'), KwProduced, FedBack, PacPre, PacPost FROM Services WHERE CustomerNumber = 1770 ORDER BY ServiceDate DESC
 
Upvote 0

mc73

Well-Known Member
Licensed User
Longtime User
True, in sqlite you should use the proposed function by Don.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Change WebView UserAgent
Replies
18
Views
12K
agraham
  • Question
Android Question Download files from WebView (local storage)
Replies
11
Views
14K
max123
  • Article
Android Code Snippet [B4X] Set date format with locale
Replies
0
Views
5K
Erel
I
  • Article
B4A Library UltimateWebView Custom View
4 5 6
Replies
116
Views
65K
Cesaral
C
  • Question
Android Question Persist webview through orientation change
2
Replies
23
Views
28K
lemonisdead
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…