PFC DateTime Service (n_cst_datetime)

The Date/Time service provides methods to perform calculations with dates.
It includes the following features:

List of Functions Available in Datawindow Expressions

Expressions are most commonly used to create datawindow column property expressions. But the are also used to create filter and find strings.

Column Display

How do I get my field to appear like a MLE and word wrap?

• In the datawindow painter, select the column
• Properties
• EDIT tab

Check AUTO VERT SCROLL and AUTOSELECTION. Other selected items may also work, however do not select HORZ SCROLL BAR. When I update a column, the change is applied to the database for many rows, not just the current one.

Check the unique Key Column in the DataWindow’s Update properties dialog box. Click the Primary Key button to assure that the columns selected are indeed unique.

Okay, in a datawindow, how do you get rid of displaying the time portion of the date field?

In the DataWindow painter, select the field and change the format property

Graying out a checkbox

If a checkbox has 3 states, and it’s state is set to that 3rd state (other), then a gray checkmark will appear in the checkbox instead of a black one.

So, by changing the state of checkbox to that 3rd state, and protecting it, it will appear to be grayed out.

Working with Dates

Day of the week

DayNumber(date)

Returns an integer (1-7) representing the day of the week of date. Sunday is day 1, Monday is day 2, and so on.

Day of month

Day(date)

Returns the day of the month 1-31.