Filed Name/column Header As Current Date

[linvall]

Hello,

I am currently trying to create a query that displays the column header as the current date. I would also like a few more headers with previous dates (date()-1, date()-2, etc...). I've been trying to input "Date()" in the header field but when I run the query, it displays "Date()" as the column header instead of the current date. Is there a way to accomplish such a thing? Thanks.

[orange]

Perhaps you should start by showing us the SQL of the query you are developing.

[linvall]

Here's what i got, pretty simple but it doesn't want to work. I need the actual date (Ex. 1/28/2019) to show up as the header.

SELECT [All Backlog WOs].WORK_ORDER_NBR AS [Date()], [All Backlog WOs].WW AS [Date()-1], [All Backlog WOs].WO_STATUS AS [Date()-2]
FROM [All Backlog WOs];

[orange]

OK. Start with a clear description of what you are trying to accomplish in simple English
--no jargon and no database terms.

Date is a very explicit thing in Access. Separate datatype with various formats and specific internal storage.
I see 3 different formats in your use of Date(), Date()-1, Date()-2. These do not represent Calendar dates, so more info is needed.

[linvall]

I need my column headers to be displayed as the current date, yesterday's date, two days ago and so on and so forth. Basically, a set of data will be in each column, depending on the date. For example, if I'm considering the first column to be the current date, the filed name should be "1/28/2019" or "28-Jan-2018" (the format doesn't really matter). The second column name would be "1/27/2019", for yesterday's date and so on and so forth.

[orange]

This is the best I could do in a few tries. Have to live with the Exp

Select " " & Date() as ""," " & Date()-1 as " " , " " & Date() -2 as "  " from YourTableName
Union SELECT YourField1, YourField2, YourField3
FROM YourTableName;

My sample with my table

Select " " & Date() as ""," " & Date()-1 as " " , " " & Date() -2 as "   " from AnimalLocs
Union SELECT SightingDate , GPSLat, GPSLong
FROM AnimalLocs;

gives result

""""""	""" """	"""   """              <-------I couldn't get rid of these and still get the dates
 28-Jan-19	 27-Jan-19	 26-Jan-19
02-Dec-09	45.32	78.44
13-Mar-09	48.9	76.33
14-Sep-10	49.3	77.7
17-Sep-10	48.9	77.334456
21-Apr-10	47.52	78.23
21-Apr-10	47.54	78.53
23-Apr-10	47.66	78.666
24-Aug-09	49.4	76.2
27-Mar-09	47.3	77.9
28-Mar-09	46.8	77.34
29-Mar-09	48.8	77.45

[linvall]

Alright, I'll take a look into this tomorrow, thank you.