I have a form with a date of Display Type _Date. This form is used as a page of type List inside a parent form.
When I enter the date in the form, there is no problem, but the date displayed in the list is off by one day. I suspect a time zone issu. My time zone is UTC-4. The workaround I did is to change the form’s display type to _Text. Now the date in the list is sync with the date in the form. However, my users lose the date picker widget in the form.
On the List page, I’m also encountering a minor issue: the time format in the form is different from the time format in the list. The time format is a custom type with Mask 99:99 and shows like this: HH:MM but the time in the list is displayed as HH:MM:SS
Actually Jean, with the information provided both are working correctly for me, could you please give me your settings for the custom Time field as well, table level and display type level?
Hi Jo. The data type is ‘date ‘ at the table level and _date a-t-il the form level. No custom display type. I attached the sample application. Maybe you can try this application with your computer set on my time zone.
We have investigated your date issue and have fixed this; I will organize an update for you soon. We can’t reproduce the Time issue you are having, could you please set that up for us in a sample app and I’ll get that looked into as well.
Well, this feature was created a long time ago and I didn’t remember that I used a custom display type…
The Display Type for the form’s field Time uses the mask “99:99” (HH:MM). After entered by the user, the string is converted to the proper Time format.
In the list I would expect that the time displays the same format (HH:MM), but it shows HH:MM:SS. You can reproduce this by using the menu item “Sales” in the sample attached. This is the same sample than before and upgraded by adding the field DetailTime in the SaleDetail table.
Just to clarify, this is not a critical issue, just a nice-to-have.
