Access Query - Data Column

[dvent]

Hi All,

I have a column that I want to set with the format of "Date" but I can't work it out.

The formula in the Column is:

GO LIVE MONTH: Format([Actual_GoLive],"mm/yyyy")

[Actual_GoLive] is found in my master data table with data type - Date/Time

Thanks
dvent

 

[jzwp22]

You will not be able to set the Go Live Month as a date because it is not a valid date, you need the day portion. What are you trying to do with the value perhaps there is another way to handle it.

 

[dvent]

I want to use the data to plot a graph with # of go lives broken down by month.

 

[jzwp22]

If you want to group your data, you will probably have to group by the year and then month. You can use the year() and month() functions to extract the parts of the date you will need; alternatively you could use the datepart() function.