I was wondering if it's possible to create a year, quarter, month, day, hour, sec without an existing date column in my data? I want to create a date and time display (X or Y axis) that I will then use to plot my data using a calculation.
As an example:
if N=N then it needs to display on November and if D=D then it will display on December.
Presuming you have a field that is "N" or "D", then you need a case statement
case [your current 'date' field] when="N" then date(#11/1/2013#)
when "D" then date(#12/1/2013#)