Archives
This is coming out of PCWorld. Looks pretty positive to our Syteline fellow. Infor Prepares to Roll out ‘Mongoose’ Development Platform
When specifying unit codes in the Excel formulas, to use both a cell reference in addition to hard-coded values, you need to append the two with ‘&’. For example, if unit code 1 value is in cell $A$1, and you don’t want to include * for each of the three remaining unit codes, the Unit […]
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) There is also a few useful UDF(User Defined Function) in Syteline ConvDate (@pInputDate DateType, @pFormat NVARCHAR(10)) Sample SELECT ConvDate(GetDate(), ‘MM/DD/YYYY’) Another useful one, DayEndOf ALTER FUNCTION [dbo].[DayEndOf] ( @Date DATETIME ) RETURNS DATETIME AS BEGIN – This function takes the input date and extends the time portion […]