JK something like this
SELECT TableOne.Recno, TableOne.ClientName, MyApp_DisplayDate(TableOne.TransactionDate) .... To do the formatting you need to call a custom function have a look in DocBook at http://127.0.0.1:1972/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_procedures#GSQL_C10574 or do a search for "SQL functions" and in the function do something like Class MyApp.Utils Extends %Persistent [ClassType = persistent] { ClassMethod DisplayDate(val As %Integer) As %String [SqlProc] { set t=$zdt(val,9) quit $p(t," ")_" "_$p(t," ",3) } Assuming that you have stored the things in COS $H format you also need some error checking to trap <val> with bad values Peter On Mon, 24 May 2004 11:04:35 +0200, "JK" <[EMAIL PROTECTED]> wrote: >Do you mean only the "Format$" or the whole >"Format$(TableOne.TransactionDate........" option and if so how would I >group the result by the format 'mmmm yyyy'. > >TIA > > >"Peter Cooper" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED] >> Guess it will be the Format$ that are MS Access functions >> >> Take these off and see if it works >> >> peter >> >> >> On Mon, 24 May 2004 10:06:28 +0200, "JK" <[EMAIL PROTECTED]> wrote: >> >> >I'm having trouble converting the below mentioned MS Access union query >into >> >an cach� union query. Can someone please help me with the correct syntax. >> > >> >SELECT TableOne.Recno, TableOne.ClientName, >> >Format$(TableOne.TransactionDate,'mmmm yyyy') AS [Transaction Date By >> >Month], Sum(TableOne.FeeAmount) AS [SumOfFee Amount] >> >FROM TableOne >> >GROUP BY TableOne.Recno, TableOne.ClientName, >> >Format$(TableOne.TransactionDate,'mmmm yyyy') >> >HAVING (((TableOne.Recno) Not In (SELECT [Recno] FROM TableOne WHERE >> >[MUDRno] <> 2225))); >> > >> >Thank you >> > >> >JK >> > >> >
