Go to Scriptcase store

# Datetime
View video

## General Settings

Datetime field Configuration Interface.

- Data Type : Define the type of field for the application. When set to Datetime, you can inform a date and time to this field.
- Search Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
- Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
- Amount of characters : Define the amount of characters allowed for the field.
- Maximum Size : Defines the size of the field.
- SQL Type : Informs the data type of field in the database.

## Values format

Datetime Field Format of Values with Regional Settings.

- Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separator and time separator attributes.
- Date separator : Allows you to inform the separator symbol for the date.
- Time separator : Allows you to inform the separator symbol for the time.
- Display : Select the format of the day/time for display.
- Internal Format : Allows to define the format the field when the SQL type is different from DATETIME. You need to use the characters A, M, D , HH, II, and SS that correspond to Year, Month, Day, Hour, Minutes and Seconds.
- Use Combo-box : Allows you to select the date using a combo-box.
  - Year as Combo : Allows to use the year combo to select the date.
    - Initial Year : First year displayed in the combo.
    - Actual Year + : Display the current plus the amount of years informed.
- Month in full textual : Displays the Month format in Full.
- Display Calendar : Enables the a calendar icon beside the field, this allows to select the date from a calendar with the format already setup.
  - New Calendar : Defines if the JQuery calendar (New Calendar) is going to be displayed or the old format.
  - Years Limit : Amount of years displayed in the calendar.
  - View week number : Displays the number of the week in the application.
  - Additional months : Displays the additional months of the calendar.
  - Show Combo year and month : Displays the year and month of the calendar in the combo box.

## Field Behavior

Date Field Behavior Interface of the Search Configuration.

- Position between values : This option sets the position that objects will be displayed.
- Text between values : Text that will appear between values.
- Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

## Special Conditions

Datetime Field Special Conditions.

- All Period : Searches for all periods of dates.
- Today : Searches in todays date.
- Yesterday : Searches in yesterdays date.
- Last 7 days : Searches the last 7 days. Ex: ((01/01/2017 01/07/2017).
- This month : Searches the dates from the first day of the current month.
- Last month : Searches the dates from the first day of lasts month.

## Display Settings

The Display Settings allows to define the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

- CSS of the Title
  - Font : Allows to choose the font type, that will be applied to the application field title.
  - Font Size : Allows to choose the the font size, that will be applied to the application field title.
  - Font Color :Allows to choose a color for the font from the color pallet.
  - Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
  - Bold : Applies the bold style to the font.
  - Underline : Applies the underline style to the font.
  - Border Size : Applies the border size to the title of the field.
  - Border Color : Allows to choose a color for the border, using a color pallet to apply to the title.
  - Horizontal Alignment : Allows to position the label of the field in the desired position (left,right,center and justify).
  - Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
  - Width : To define a width for the title of the field.
  - Height : To define a height for the title of the field.
- CSS of the Field
  - Font : Allows to choose the font type, that will be applied to the application field.
  - Font Size : Allows to choose the the font size, that will be applied to the application field.
  - Font Color :Allows to choose a color for the font from the color pallet.
  - Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
  - Bold : Applies the bold style to the font.
  - Underline : Applies the underline style to the font.
  - Border Size : Applies the border size to the field.
  - Border Color : Allows to choose a color for the border, using a color pallet to apply to the field.
  - Horizontal Alignment : Allows to position the field in the desired position (left,right,center and justify).
  - Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
  - Width : To define a width for the field.
  - Height : To define a height for the field.
- CSS of the Input Object
  - Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
  - Font Size : Allows to choose the the font size, that will be applied to the application field.
  - Font Color :Allows to choose a color for the font from the color pallet.
  - Background Color : Allows to define the color for the Input Object, the color can be selected from the color pallet.
  - Bold : Applies the bold style to the font.
  - Underline : Applies the underline style to the font.
  - Border Size : Applies the border size to the Input Object.
  - Border Color : Allows to choose a color for the border, using a color pallet to apply to the Input Object.
  - Horizontal Alignment : Allows to position the Input Object in the desired position (left,right,center and justify).
  - Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
  - Width : To define a width for the Input Object.
  - Height : To define a height for the Input Object.

## Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

- Help Description : Allows to inform a text that will present to the user when he positions the mouse over the field.
- Help Type
  - Pop-Up : Selecting the pop-up type, it will display an icon beside the field that when clicked, you will view a pop-up with help description.

  Help type - Pop-up configuration Interface.

  - Hint : Passing the cursor over the field, you will view a hint with the help description.

  Help type - Hint configuration Interface.

  - Text : It will display the help description beside the field.

  Help type - Text configuration Interface.

#####

#####