Date Conversion

[Welthey]

Ok, I have read through numerous posts and I can seem to find what I am
looking for when it comes to converting a date that I have. My date was
imported into the database 10dec07, in order to get a date calculation I need
to convert the date to a date/time field and show the date in the short date
format. Is there something that can put in my query to have the date
formatted differently?

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
FROM qry_SEARSFADFILE_orig_MinTime_Date;

 

[Welthey]

I'm continuing to research this and tried the following SQL statement but all
is does it put the ModDate in the same format that it was in before.

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
(Format([AUTHDATE],"mm/dd/yyyy")) AS ModDate
FROM qry_SEARSFADFILE_orig_MinTime_Date;

 

[KARL DEWEY]

If AUTHDATE is not a DateTime datatype it will not format to an other date
format. The function only works on dates.

How is the data there now - I assume it is a text datatype? And is
MinOfFFSL_TIME_HHMMSS a text or datetime field?
--
KARL DEWEY
Build a little - Test a little

I'm continuing to research this and tried the following SQL statement but all
is does it put the ModDate in the same format that it was in before.

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
(Format([AUTHDATE],"mm/dd/yyyy")) AS ModDate
FROM qry_SEARSFADFILE_orig_MinTime_Date;

Ok, I have read through numerous posts and I can seem to find what I am
looking for when it comes to converting a date that I have. My date was
imported into the database 10dec07, in order to get a date calculation I need
to convert the date to a date/time field and show the date in the short date
format. Is there something that can put in my query to have the date
formatted differently?

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
FROM qry_SEARSFADFILE_orig_MinTime_Date;

 

[Welthey]

They dates are text fields. When they were imported in, that was the only
way we could get to import. The MinOfFFSL_TIME_HHMMSS is actually a time
field.

If AUTHDATE is not a DateTime datatype it will not format to an other date
format. The function only works on dates.

How is the data there now - I assume it is a text datatype? And is
MinOfFFSL_TIME_HHMMSS a text or datetime field?
--
KARL DEWEY
Build a little - Test a little

I'm continuing to research this and tried the following SQL statement but all
is does it put the ModDate in the same format that it was in before.

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
(Format([AUTHDATE],"mm/dd/yyyy")) AS ModDate
FROM qry_SEARSFADFILE_orig_MinTime_Date;

Ok, I have read through numerous posts and I can seem to find what I am
looking for when it comes to converting a date that I have. My date was
imported into the database 10dec07, in order to get a date calculation I need
to convert the date to a date/time field and show the date in the short date
format. Is there something that can put in my query to have the date
formatted differently?

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
FROM qry_SEARSFADFILE_orig_MinTime_Date;

 

[KARL DEWEY]

To use date formating on a text field you must convert it to a date content.
Based on the content in the text you must parse it and convert to date.

What is the text format in the text field AUTHDATE?

--
KARL DEWEY
Build a little - Test a little

They dates are text fields. When they were imported in, that was the only
way we could get to import. The MinOfFFSL_TIME_HHMMSS is actually a time
field.

If AUTHDATE is not a DateTime datatype it will not format to an other date
format. The function only works on dates.

How is the data there now - I assume it is a text datatype? And is
MinOfFFSL_TIME_HHMMSS a text or datetime field?
--
KARL DEWEY
Build a little - Test a little

I'm continuing to research this and tried the following SQL statement but all
is does it put the ModDate in the same format that it was in before.

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
(Format([AUTHDATE],"mm/dd/yyyy")) AS ModDate
FROM qry_SEARSFADFILE_orig_MinTime_Date;


:

Ok, I have read through numerous posts and I can seem to find what I am
looking for when it comes to converting a date that I have. My date was
imported into the database 10dec07, in order to get a date calculation I need
to convert the date to a date/time field and show the date in the short date
format. Is there something that can put in my query to have the date
formatted differently?

SELECT qry_SEARSFADFILE_orig_MinTime_Date.AUTHDATE,
qry_SEARSFADFILE_orig_MinTime_Date.MinOfFFSL_TIME_HHMMSS,
qry_SEARSFADFILE_orig_MinTime_Date.FFSL_ACCOUNT_NUMBER,
FROM qry_SEARSFADFILE_orig_MinTime_Date;