How do i format date and currents in a query such that the output is: for currents $ ### ###,## and DD/MM/YYYY ?
Printable View
How do i format date and currents in a query such that the output is: for currents $ ### ###,## and DD/MM/YYYY ?
u can try formatting the fields that you display at. :)
Hi you can convert your date to UK format in your sql query like this
Select CONVERT (nvarchar(20), Yourdate, 103)
then use this value in your report
thanks