Discussions tagged DATE
Hello,
Using Powerbuilder 2022 b1900, Postgresql 15
Have a computer column in a datawindow, defined as cast(null as date) as expiry along with few database columns. 1. EditMask of the expiry column set to MM/yyyy2. Format of the expiry column s...
Hi friends,
How do add days to a datawindow smalldatetime field in script? I'm trying to compute an invoice due date based on the invoice date and the selected terms (30, 60, 90, etc).
TIA,
Tracy
...
I have the following code:
string ls_date = "1900-01-50"date ld_dateld_date = date(ls_date)messagebox("Date", string(ld_date, "dd-mm-yyyy"))
When run using PowerBuilder 12.5.2 (my legacy system) the result in the messagebox is...
Hi Gurus
We have an application where all the date fields are masked DD/MM/YY and when we enter the data 31/01/50, it converts in 31/01/1950 rather than 31/01/2050.
Till year 49 it's fine and convert into 2049.
Although if I change the maski...
Hello all,i have a Mobile application with a Date column in a datawindow
i set the mask and format to dd/mm/yyyy
changing the date (the column have no validation at DW level) we get and invalid data errror (atteched picture)
i have check the Date ...
Hi
This is Prashant here I am facing probem with unicode numeric datatype. Which I believe could be for numeric values unicode \u and I set Edit mask Format = ###,###. If I removed Edit Mask and allow it return garbage value.
If fails to enter nume...
Hi,
is there a function in a PowerBuilder Mobil App to read the datetime when the app was deployed to the server?
Kind regards,
Ludwin
...
Hi All,
Not sure if this has been asked before, but struggling to find direction on what to do.
Is there a way to determine the Language & Region and therefore the Date & Time format used on a mobile device using Powerserver Mobile.
We have an app...
Hi All,
One of our PB apps is used in multiple timezones, with users in those differing timezones hitting the same Oracle table rows, based on their role. Because of that, the varying timestamps in our tables are off, making it rough to report on...
Is there a way to view the update sql statement generated by a dw?
...
Hi All,
I want to change the format of date time displayed without having to modify SQL query . Currently it is displaying "9/19/2017 08:29:25 " i want to change it to "19 MAR 2017 08:29:25" . same case with decimal values , it is showing ".6" in...
Hi. We're currently experiencing an issue with a 64-bit .exe created with PB 12.6 Classic (build 4098) running on workstations with Win 10 Fall Creators Update (Build 1709).
The application runs fine on previous versions of Win 7 and 10, and ...
In one of my machines when trying to connect it to subversion I get the following message :
PBSCC Proxy : version 2.01.78 built on 2010-10-16
PBSCC Proxy : svn work dir: .svn
PBSCC Proxy : svn: E155036: Please see the 'svn upgrade' ...
Hi,
I just migrated my project to PB 2017 1681 and run into an error because the behavior of the powerscript function date(string) appears to be changed. In PB 12.6 this:
date('2018-01-53') returns 1900-01-01, what I need.
But in PB ...
Hi,
I am from Latin America and I am migrating from pb1251 to pb2017, what should I do to make the date appear with 2017-ene-23 and not in English format like 2017-jan-24. There is something similar to EBF20964_localizaded.
Thanks in advance ...
- Page :
- 1