Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

UDT_FUZZYDATE

Converting a standard datetime to a UDT_FUZZYDATE

By: Joseph Styons

Posted on: December 18, 2012

CRM comes with a user-defined type called “UDT_FUZZYDATE”. If you look at that datatype, you’ll notice that it’s just a CHAR(8) field. Converting from a standard datetime to a UDT_FUZZYDATE can be done pretty easily using native SQL. Anybody reading this blog could figure this out on their own, but here it is just to save you the typing. if exists(select * from information_schema.routines where routine_name = 'usr_ufn_datetime_to_fuzzydate') begin drop function usr_ufn_datetime_to_fuzzydate; end; GO create function usr_ufn_datetime_to_fuzzydate ( @dt as datetime ) returns udt_fuzzydate as begi... Read More
Categories: ,

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean