How do you format query text to date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two date fields. I need to compare the two dates to find the most recent date and pull that date into one field (w/o appending it to a table) to use for reporting purposes. So far what I have done is write 3 queries. The first pulls only the values that are more recent from column 1, the second pulls only values from column 2 that are more recent. Then I concatenate them in a query to pull both into one column, which turns the values from dates to text.

This solution is fine expect when i need to limit the date criteria. Does anyone know how I can do this and keep a date format? Or how I can change the text values into date values.

I am fairly need to this and I do not know how to write code so the solution needs to be as simple as possible.

Thanks!
 
I have two date fields. I need to compare the two dates to find the most recent date and pull that date into one field (w/o appending it to a table) to use for reporting purposes. So far what I have done is write 3 queries. The first pulls only the values that are more recent from column 1, the second pulls only values from column 2 that are more recent. Then I concatenate them in a query to pull both into one column, which turns the values from dates to text.

This solution is fine expect when i need to limit the date criteria. Does anyone know how I can do this and keep a date format? Or how I can change the text values into date values.
Click to expand...

A Query will not, per se, turn a value into text. Could you post the
SQL of the query? Are you using the Format() function - which DOES
convert to text?
 
Back
Top