FORMAT date examples (SQL 2012 and later)

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our PP (Def Revenue) scripts. All of our scripts for Dynamics GP can be found here

	PP (Def Revenue) Scripts
	No records to display.

Leah
4Penny.net
Points: 7749
2/18/2019 10:19:15 AM

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

I'm all about speed. Seriously. It's a flaw.

I need to know how to (quickly) use the SQL FORMAT function to format dates.

Here's my cheat sheet.

Version: All

Section: SQL Scripts

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables

DynDeveloper.com