how to convert date into text fomat

Share icon

Mon, 02/10/2014 - 05:07 pm

Hi All,
I`m processing my data and need to make category plot.
Right now I need to use date"Day column" as x-axis which igor dose not allow me to do that.
I need change the format from "date" to "text"

Is there anyone can teach me how to do that ？

My data was attached if you want to look at it.
Thank you very much.
Yi Experiment_1.pxp
The "day" wave is numeric and is actually the full date and time as the number of seconds elapsed since Jan 1, 1904.

To get a corresponding text wave with that date (only), you can do this:

Make/O/T/N=(numpnts(day)) dayAsText= Secs2Date(day,0)

--Jim Prouty
Software Engineer, WaveMetrics, Inc.

February 10, 2014 at 05:47 pm - Permalink

JimProuty wrote:
The "day" wave is numeric and is actually the full date and time as the number of seconds elapsed since Jan 1, 1904.

To get a corresponding text wave with that date (only), you can do this:

Make/O/T/N=(numpnts(day)) dayAsText= Secs2Date(day,0)

--Jim Prouty
Software Engineer, WaveMetrics, Inc.

Thank you so much Jim. It is very help. Can I choose only to show Month and year, such as 04/2012 instead of 04/01/2012 ?
Thank you very much.
Yi

February 11, 2014 at 11:28 am - Permalink

lyggd wrote:
Thank you so much Jim. It is very help. Can I choose only to show Month and year, such as 04/2012 instead of 04/01/2012 ?
Thank you very much.
Yi


•Make/O/T/N=(numpnts(day)) dayAsText= Secs2Date(day,0)
•dayAsText = StringFromList(0, dayAsText, "/")+"/"+StringFromList(2,dayAsText,"/")


--Jim Prouty
Software Engineer, WaveMetrics, Inc.

February 12, 2014 at 12:44 pm - Permalink