Background: I recently moved to Queensland (Australia) which doesn't have daylight savings like the southern states (where I'm from) do. Consequently, during summer the sun comes up at the ungodly hour of 4:45am or thereabouts.
It got me thinking, would it be possible to design...
I run a request to a web server with the Maria SQL database, in the response I get a field with a date in the TIMESTAMP(6) format. I want to store the value of this field into a variable. But at me it turns out to save only in a string. Then it is not convenient for me to process it. How can I...
Would like to know how DateTime.Now arrives the value in B4A and B4J.
Does it takes the value from computer?
Does it requires any internet connection to fetch value from somewhere?
Changing the computer system's Date and Time,
In B4A, it returns the correct value. Then...
Hi all and happy 2021.
I'm run into the problem (yes, I know, my fault).
The problem is that I saved date into my table like this 05/05/2020. For the whole year it was OK but this morning I realized that I did it wrong.
When I run a query like this
select * from mytable where jobdate between...
On a B4Xpage we have two DatePicker field txtFromDate and txtToDate
How to set these field from code, having a date like a string value?
txtFromDate.DateTicks = ???
Wich function that return a DateTicks from a string (example "14/09/2020") ?
can certainly still be optimized.
Private Sub isCurrentMonth(ticks As Long) As Boolean
Return DateTime.GetYear(ticks) = DateTime.GetYear(DateTime.Now) And DateTime.GetMonth(ticks) = DateTime.GetMonth(DateTime.Now)
Private Sub isSameYear(ticks_1 As Long,ticks_2 As Long) As...
DateTimePicker view is based on the CustomListView and snapCLV with a design similar to the ios datetime picker. This view has only been tested in B4A, it is not very useful in B4i since for ios the built-in picker is better.
1. Add the module and layout to your project (attached...
I'm trying to convert a 24 hour time to 12 hour with AM/PM. I've tried to use the documentation for date/time formats.
Here's my code:
Dim TimeString as String = "21:00"
Dim TimeValue=DateTime.TimeParse(TimeString&":00") as Long
DateTime.DateFormat= "h:mm a"...
For Android and iOS.
Change (DateTimeChange As Long)
Class_Globals As String
DesignerCreateView (Base As Object, Lbl As Label, Props As Map) As String
Base type must be Object
Initialize (Callback As...
I know this been discussed here quite a few times, but I still am unable to format an SQL date field as I desire, it keeps showing me the date as yyyy-mm-dd...
I tried the following code and the result is always the same: yyyy-mm-dd
DateTime.DateFormat = "dd/MM/yyyy"