Troubleshooting seconds-> date/time function in axis menu

I have two y waves plotted against the same x wave, the x wave is in seconds since 1/1/1904. I need the wave to stay in the seconds format, but would like to display the graph's x axis in normal mm/dd/yyyy hh:mm:ss format. This should be achievable by going to the axis manual range settings and changing entry format from numeric to Date&Time. When I select this option, the preview max and min values show the correct format, but when I click 'Do It,' the graph remains in the original seconds format.

Am I missing something easy here? Or is the best option to convert the wave I'm using as the x axis to a time/date string and use that?

Post your experiment, please.

A simple test shows the x axis using date format properly:

make/O wy=sin(x/8)
make/O wx= datetime+p*3600*24
display wy vs wx

 

After double-clicking the bottom axis and choosing "Date/Time" format, the bottom axis shows the dates because the dialog altered wx's data scaling to "dat":

 

//Axis "bottom" mode changed to date/time mode. Units for wave "wx" changed to "dat".

 

dateaxis.png (7.95 KB)

I apologize for not attaching a file, since it was a general question I decided to forgo it initially. I was changing the axis range to date/time instead of the axis units- hence the error.

 

Thank you for your prompt response.