Search results

Thank you for your reply. Date and Timestamp we are getting from DB2 database. It is capturing the milli seconds also. So it 12:30:09 sec and 05 milli seconds I need to get the max timestamp for each document contro number

Date is 20080521 and time is 12300905

How to return to Post #7

1) Date format is Text. I tried to convert to Date/Time. But when I update table, it is deleting all records saying there is an error 2) Time stamp format is in 8 degit. For Ex: 12300905

1) Text. I tried to convert to Date/Time. But when I update table, it is deleting all records saying there is an error 2)tbl_mbrshp_fulfilmtSTATETM12300905

Still having problem. I need to convert 8 digit timestamp to 8 digit in access. Will access supports milli sec

I got the date displayed in Mm/dd/yyyy hh:mm:ss format. But when I convert that field to date/time in table it is throwing an error. It is still taking it as a text. How to convert it to date format. I need to get the most recent date from the whole list of dates

My table has a data field from where I am getting data by month Now my users need to see the data for current month only next month 1st i.e currently we are in August month. When they run report they should see only Jan till July data August comes into picture only on Sep1st when they run...

I have a date in my access table as yyyymmdd whose datatype is text I am using format([date], "mm/dd/yyyy") to convert to date in mm/dd/yyyy It is throwing error #Error Can anybody help me on this

I have data coming from Excel sheet not AS400 directly. Also I have two fields both date and time Just need to convert time to hh:mm:ss AM

I have date coming from AS400 date. Statedt is in yyyymmdd format Statetm is in hhmmss000 (millis sec format) For ex: Statedt is 20080521 Statetm is 12300905 Here is the attached file I have with date and time I need to find the most recent State by using date and time Can anybody help...

Not working I tried working on Crosstab query. It is not showing data by weekend. Can you help in getting this. I tried all the options today. May be I am not great in analysis

Even iif() is giving me error in Business Objects when running query. Parsing is OK but when running it is giving me too few parameters errors Do you have any idea about this error ??

Hey..This is working fine. But I need to see data groupby each weekend in that criteria. For Ex: If I enter date 7/25/2008, Total should be group by each weekend 7/4, 7/11, 7/18, 7/25 and display these dates in column headings Also If I enter 7/28, it should give me data only upto 7/25 with...

Switch function is not working in Business Objects. Can you let me know how to write the same query using iif()

Here is the query I am using to get this done. Here is the query I am using at Acces which is working fine.But Dateadd function is giving me error when I use this in Business Objects Can anybody help me the other workaround for this ?/ SELECT X.week AS week, sum(X.TotalCalls) AS [sum]...

Don't need Timestamp I am not working on Timestamp field. I have Time field with values A, B, C, D etc. I just need to hard code them to see if Time value is A then display as 8-9 . I used iif and switch statements which didnot work Can you tell me how to do this and syntax

I have a date field in my table in format m/dd/yyyy hh:mm:ss AM. Depending the date selected by user, I need to display the corresponding month's data like previous 4 weeks If the month begining falls in weekday other than Monday, It should give the whole month begining week's data For Ex...

I have a table with Time column which has values like A, B, C, D until J. I need to hard code them if Time is A then 8-9 and if time is B then 9-10 etc I tried both iif and switch functions which are not working Please advise me on how to write ?? Am I missing any syntax ??

I have a table with Invoice Number, State, State dt, State tmstp State has 5 values like Delivered, spooled, prepared etc. I need to get the the state of a invoice number with most recent date and time tmstp. For ex: if I have 4 states for a invoice with different dates and time, I need to...