I have altered the application to now record the correct date function.

But i am still struggling to get it to show todays data only

Ok i see what you are saying so how do i change the format so my SQL date is 2021-09-06 instead of 2021-06-09 as my language is UK?

Hi Ant,

You are incorrect the  date data in the image is:

3rd of September 2021 & 6th of the September 2021

I agree this will no doubt have to changed to be...

Hi DesNorton,

I have edited the query to as you advise but it returns no results.

My data is generated from a VB.net Windows application, i would like to get this resolved...

Hi  Ant,

With your code you advised and I have altered it this seems to working as i require:

;WITH CardSwipeCTE AS (
SELECT ROW_NUMBER() OVER (PARTITION BY RFID ORDER...

Thanks Michael,

I will test your SQL Query and let you know if any problems.

Cheers James

I am really CONFUSSED why do i have to create a table i already have a table called [job Info$] with a column called [Time Reported] all i want to...

Hi Cath Trimble,

SELECT FORMAT(DateTimeCol, N’HH\:mm’)

FROM #TimeReported;

Errors on DateTimeCol & N' "Invalid coloum changed DateTimeCol to ['Job info$'].[Time Reported] error could not be bound.

Also changed #TimeReported to ['Job info$'].[Time Reported]

Cheers James

I have had a go at righting my own query but having a few issues. As per the norm thanks for everyones assistance so far.

/*Create new colunm...

Hi morenoj5958 81627

That worked to a point :0) but i would like to change the values in time reported to those generated and i would like also to remove the...

Hi Grasshopper,

I already have a table called job info$ and in column Time Reported i have 29602 rows i need to change all of them.

Are you suggesting creating a new...

• This reply was modified 5 years, 5 months ago by  jamesstirling01.

To hopefully assist further the table is called Job info$ the column is called Time Reported

Thanks rVadim but the 'Time Reported' is a different time in each row for example:

1899-12-30 09:12:32.000 -Row1

1899-12-30 09:13:12.000 -Row2

1899-12-30 09:21:39.000 -Row3

1899-12-30 09:24:04.000 -Row4

Does not work with FQDN 127.0.0.1 address same error.

Thanks for all the assistance i have sorted what i require.

Thanks once again.

James