From a recent email:
I am trying to use SmartList Builder to build a query where a calculation is required showing the number of days an A/R transaction is past due. Obviously, I have the DOCDATE from RM20101 but I need a column that tells me the current date so I can make this comparison…and I am not sure if there is a SQL Server table that I can pull in that shows this information to me. I am pretty certain that there is not a GP table with current date in it just sitting there by default.
Answer:
Select getdate(), convert(varchar(10),getdate(),101)
Getdate() returns a date/time, the second part will strip the time