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)
End Sub
Private Sub isSameYear(ticks_1 As Long,ticks_2 As Long) As...
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"
DateTime.DateFormat="HH:mm"
Dim TimeValue=DateTime.TimeParse(TimeString&":00") as Long
DateTime.DateFormat= "h:mm a"...
(Here for iOS version)
SD_DiscTimePicker
Author: Star-Dust
Version: 0.03
DiscTimePicker
Events:
Change (DateTimeChange As Long)
Functions:
Class_Globals As String
DesignerCreateView (Base As Object, Lbl As Label, Props As Map) As String
Base type must be Object
Initialize (Callback As...
Hello guys,
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"
wDataEvento...
DDL code:
[entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000)
Make sure that the expression (strftime('%s','now') *1000) is enclosed in brackets.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.