Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

date object.

Go down

date object. Empty date object.

Post  Afaf Tue Sep 18, 2012 9:45 pm

need to create an objet at universe level that will be restricted to fetch yesterday 7:00 am to today 7:00 am.

The field name is dateLoaded, which is a datetime, and displays Date time in list of values.
DB is sql 2008.

Plz help me......

Afaf

Posts : 14
Join date : 2012-09-18

Back to top Go down

date object. Empty Re: date object.

Post  Afaf Wed Sep 19, 2012 8:14 pm

after trying all... i got this working superbly fine...

"InspectionSheet.DateLoaded between
DATEADD(dd,-1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + '
07:00:00',120)) and
CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + ' 07:00:00',120)"

Afaf

Posts : 14
Join date : 2012-09-18

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum