Skip to Content
Former Member
Nov 02, 2010 at 02:44 AM

Date Format Displaying as Jan 01, 1900



I have table which receives the output from the BI query. There is a data field which is coming as text in VC. The format of this text is YYYYMMDD. This I used formula


to display in the table as DD.MM.YYYY.

When clicking on this row item the user can edit the details in a form by an onselect action. The formula used here is


The date is shown in the date picker to the user. The user can select the date from the date picker and then save the values.

The problem I am facing is, if there is any value in the date parameter it displays correctly in the date picker. But if the date field has a value 0000000 then defaults to Jan 01, 1900. I want to display as empty or # in date picker box .

Can someone give me insights on this?