Database Reference
In-Depth Information
4. The syntax of your query is validated. Click on
Done
to close the
Advanced Ed-
itor
.
5. On the right-hand side of the query editor, rename your query to
ToLocalTime
for the example used in this recipe.
6. Click on the
Home
tab. Click on the
Close & Load
button and select
Close &
Load
to save your query.
7. Loading of functions is disabled by default. To use your functions, you must
right-click on the query that you want to use the function in and click on
Edit
.
8. The
Query Editor
dialog opens. Click on the
Add Column
tab and then on the
Add Custom Column
button. The
Add Custom Column
option is displayed:
◦ Provide a column name, such as
Locale Created Date
for this ex-
ample
◦ The formula will be
ToLocalTime([CreatedDate])
9. Click on
OK
.