Is there a function that will convert a string to date in SmartList Builder?

(0) Share

Report

Posted on by Dawn Prigmore

I have a client who uses a User Defined field to store a date. The format keyed into the string field is consistent (MM/DD/YY) and I'm able to sort and report on that field. I've written several reports in SRS that convert that field to a date field, in order to use it in parameters, and I need to do the same in SmartList Builder. I can't seem to get there and any help would be greatly appreciated! The goal is to create a calculated field in SmartList Builder so I can use that field in SmartList search options.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Dawn Prigmore on at

Like (0)

Report

RE: Is there a function that will convert a string to date in SmartList Builder?

In hindsight, this was fairly simple, but sometimes it's nice to have an example:

CONVERT(datetime, {table.field name}, 01)

replace "table.field name" with the string field you need to convert.

Was this reply helpful? Yes No