Fjerne klokkeslettet fra dato/klokkeslet

hvis det virker på samme måde som i access, kan du bare skrive date() hvorimod hvis du skriver now() får du hele pivtøjet...

Try creating a query in Access

SELECT format(dato, "dd-mm-yy") as YourFormattedDate From YourTable

then use the query in your ASP.NET application instead of the table

Men hvis der skal stå klokkeslæt i databasen også så prøv med

SELECT LEFT(Felt, 10)

Når jeg prøver at gøre som Terry siger, skriver den "End of statement expected" som compilation error..

Min Sql-streng ser således ud:

strSQL = "SELECT format(dato, "dd-mm-yy"), Time, Venue, Location FROM Tourplan ORDER BY Date"

You are NOT doing as I say!

Do you have a field named dato or is it date? field names suchas date and time are reserved words so should be placed in []



strSQL = "SELECT format([date], "dd-mm-yy") AS YourDate, [Time], Venue, Location FROM Tourplan ORDER BY [Date]"

You will very likely need some extra " in the string
try
strSQL = "SELECT format([date], ""dd-mm-yy"") AS YourDate, [Time], Venue, Location FROM Tourplan ORDER BY [Date]"

and if that doesnt work

strSQL = "SELECT format([date], """dd-mm-yy""") AS YourDate, [Time], Venue, Location FROM Tourplan ORDER BY [Date]"

I'm sorry

The field name is called Date

Now my SQL-string looks like this:

strSQL = "SELECT format([date], "dd-mm-yy") AS [date], [Time], Venue, Location FROM Tourplan ORDER BY [Date]"

Still it writes back that "End of Statement is expectet"!

Come on Terry, please help, you'll get the points! :-)

HEY!! IT'S WORKING! :-D

what did you do to get it working?

Now it looks like this:

strSQL = "SELECT format([date], ""dd-mm-yyyy"") AS [Date], [Time], Venue, Location FROM Tourplan ORDER BY [Date]"

Yes I though so, you need to use double "" as the first gets removed

og tak