It is the tool that shows the date and time together when it is dragged and dropped into the designed form.
‘’Date Time’’ icon at Toolbox
How it looks like on the Canvas
Properties
Properties of the form tool;
-
Name: The name of the tool will be written here.
-
Default Value: The value entered here comes into the Date Time tool by default. If you want to enter data as the default value, you can write in the Default Value part. It fills the date area on the client screen.
-
Text Size: Sets the size of the tool.
-
Help Text: It is the text that is entered for comment when the mouse is placed on the tool.
-
Icon: Select the icon, color, and position to be added to the tool.
-
Text Fonts: Allows you to change the font.
-
Text Type: Adjust the type of text like bold, italic, underlined, and replaces the text as right-aligned, left-aligned, or centered.
-
Color: Edits the color of inside the tool and/or the text inside the tool.
-
Height / Width: Adjusts the height and width of the tool.
-
From Left / Top: Adjusts the distance of the tool from the left and top.
-
Linked Object: Links to an object element created by action. When the object element runs, the information is filled in according to the object area.
-
Linked Object Area: Selects the fields within the linked object area.
-
Tab Order: Specifies the order of the tool within the form.
-
Time Interval (min.): Determines the minute interval of the time area.
-
Fit horizontal: Fits the tool to the full screen on the user’s screen.
-
Pin Right: Pins the tool to the right.
-
Display: Makes the tool not appear on the screen.
-
Form Only: The information entered in the tool is not saved to SQL, but only in form.
Actions
-
On Focus: Assign an “Action” as on focus handler. For more information please click here.
-
On Blur: Assign an “Action” as on blur handler. For more information please click here.
-
When the value changes: Assign an “Action” as on value changes handler. For more information please click here.
-
Keyboard Input: Assign an “Action” as on keyboard input handler. For more information please click here.
-
Validation: Assign an “Action” as on value tool handler. For more information please click here.
-
Calculate: Assign an “Action” as calculate handler for grid tool. For more information please click here.
-
Icon Clicked: Assign an “Action” as click handler for the icon. For more information please click here.
Examples Used
To change the hours on the client screen, you can write a number as a minute in the Time Interval area.
When it is seen hour icon on the right;
Client view on screen
For example; In a reporting screen, you are asked to filter by receiving data from the date-time field, but the time information is not requested. To do this, a conversion operation is required when selecting the date-time in the reporting screen. The query format must be written as follows.
SELECT CONVERT(DataType, ColumnName, FormatFormat)
e.g. ” SELECT CONVERT(Varchar, getdate(), 104) ”