News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Is there a function th...

Microsoft Dynamics GP (Archived)

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

(0) Share

Report

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

All responses Img

All responses (1)

Answers Img

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans