I’d like to highlight another handy little project freely available in the m-Power Project Exchange, but this time it’s not a template–it’s a user defined function (UDF). If you’re unfamiliar with the term, here is a great explanation of UDFs and how m-Power uses them.
This UDF fixes a common problem with MS SQL databases. As you may know, the MS SQL database uses date/time fields. In other words, if you want to pull the date from a MS SQL database into a web application, it will give you the date and time, not just the date. Obviously, sometimes you just want the date.
This is where the Date/Time Conversion UDF comes into play. It takes the date/time field and then converts and displays it as a new date-only field. If you use the MS SQL database this UDF could save you quite a bit of time.
This project is free to any m-Power user. If you want to learn more or download this project, click here.