Topics Search

Changing Dates In A Table

Changing Dates In A Table
Views: 0
I have about a million records in a table. Each record has a "File Date" column which lists when the record was saved. There are about 20 different "File Dates" for the million records. Unfortunately, these dates are just a bit off (1 day later than what they should be). What's the best way to change all of "File Dates" in this table?
Sponsored Links:

More topics

 

Using date variables from table in query

Preview
I have a table that contains dates (Saturday through Friday). When I set up my query, I would like data returned where the date in a field is between the Saturday date and Friday date. Is there anyway to do this n the query without hard coding the dates in and manually changing the dates every week?
 

MS Access A Different Between Dates Problem

Preview
I have a table (A) with close to 1000 distinct dates. I have another table (B) with hundreds of thousands of records, each of which contains a "From Date" and "To Date".

I need to find all of the records (Dates) in table A that are not encapsulated between any of the From-To dates in table B. In layman's terms, which dates in table A were missed in table B.

Table B may have From-To overlaps, or gaps. There is no relation between tables A & B other than checking if date in table A is between From-To in any record intable B.
 

Date day and month being swapped

Preview
I am having trouble with entering dates into a database. When I enter a date some of the day and months are swapped. What happens is this:
if I enter 03/05/2009 (3rd of May) it is desplayed as 05/03/2009 (the 5th of March), However if I enter a date where the day is after the 12th of the month this does not happen for example 13/05/2009 stays 13/05/2009.

I have tried changing the input masks and the format of the column and I have even removed these settings, but the computer still does this. I am trying to copy many records from a different database into this one, so manually changing or fixing these dates is not an option.

Can somebody please help me so that I can stop bashing my head against the table
 

How Do I Convert a Date in Access to a Serial Number

Preview
I'm using a text data type (for numerous reasons, using date data-type is not an option) for my Dates columns and they were all running fine but after changing data types and changing them back, they all became serial numbers.

Can't figure out how to convert them back to dates whilst still in the text data-type.

Tried using "dd/mm/y/" (works in Excel but not Access?) in the format field for my dates however they stay put as Serial numbers.
 

Expression do not keep date format

Preview
I have a HUGE query (about 5 A4 pages). This query is the source for a Excel Pivot table.

The Pivot tables ONLY contain row labels --> no values.

Most of the fields in the query are expressions like: iif(isnull([FIELD];"";[FIELD]) otherwise I'll receive cells containing "(Blank)" in my Pivot table which confuses the users.

This works fine except for the dates. The dates are formatted to text! In the Pivot table the users can't filter properly on the dates (e.g. sort by oldest to newest etc.). ATMthe dates are sorted by the day no matter month and year.

I have tried setting the fields Format (Property Sheet) to Short Date and Long Date. And I tried changing the expressions to iif(isnull([FIELD];"";Format([FIELD];"Long Date")). I have also tried with "dd-mm-y".
 

Parameter query as a controlsource

Preview
I have a parameter query with 'From' and 'To' dates that I create a report with. Is there anyway to use the From and To dates as a control source for the report ? I'd like the report page to include the dates as a header, since they will be changing
 

Working with Complex Queries that Calculate

Preview
Whenever you develop a commercial application, there is absolutely no way that you can get by without using date fields. The Video application has Movie Rental date, Return date, Date-of-birth, Report dates. The Dating Service has dates for dates. The Credit card has an Expiry date. There are Birth dates, Hire dates, Delivery dates, Order dates, and so on, and so on.
 

Comparing 2 columns against 2 other columns

Preview
This may be a noob question, but how can you run a query comparing an ID number and a date against another table of ID numbers and dates?

I have everything loaded and ready to go, can easily compare ID vs ID, but one of the tables has a couple dates only per ID (that we need) and the other table has a large amount of dates in there that we do not need.

Basically, trying to match up two columns on the smaller table to two columns on a much large table.
 

Working with departure dates

Preview
I already have a table called TourName and those names are already in the table. One tour may have several date departures during the year and some only one departure.
I need to show departure dates (TourDates) for those respective tours and then have the form display those departure dates.
Should I create another date table or just add more columns to the existing TourName table . but I have doubts that would work well.
 

Working with departure dates

Preview
I already have a table called TourName and those names are already in the table. One tour may have several date departures during the year and some only one departure. I need to show departure dates (TourDates) for those respective tours and then have the form display those departure dates.

Should I create another date table or just add more columns to the existing TourName table . but I have doubts that would work well.