FormatDateTimeForSQL

Structure

FormatDateTimeForSQL(dtValue)

Parameters

| Parameter | Type | Description
| dtValue | Numeric* | date to be formatted. Dates are numeric values. Often this value is returned from another custom rule function like 'LookupEventAttributeDate'. Since the value is numeric, you can also use LookupEventFieldNumeric for date-based fields like LookupEventFieldNumeric('RETURN_DATE') |

Return Value

String

Description

This function takes a date and formats it as a string appropriate for use in sql against the current IndySoft database. Different database backends require certain date formats, as defined in Database Settings dialog. This function utilizes these settings to properly format the date for sql.

Example

No example provided

Application Compatibility

IndySoft Calibration Management, IndySoft Commercial Lab Management, IndySoft Tool Management

Also See

No related topics |