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...
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"...
(Here for iOS version)
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"