I have a custom table with a Date/Time field named PressedButton.
This table also has an Integer field named Year, an String field named Month, and an Integer field named Day.
When I run this:
var nowdt = gs.nowDateTime();
var gr = new GlideRecord('u_my_custom_table');
gr.u_pressedbutton = nowdt;
gr.insert();
Everything works great. The record is inserted and the date/time field shows up perfectly.
I now want to populate the other fields with the breakdown of gs.nowDateTime(). For example:
var nowdt = gs.nowDateTime();
var gr = new GlideRecord('u_my_custom_table');
gr.u_pressedbutton = nowdt;
gr.u_year = gs.nowDateTime(yyyy);
gr.u_month = gs.nowDateTime(m);
gr.u_day = gs.nowDateTime(dd);
gr.insert();
But as we all know, my parameters in gs.nowDateTime() are invalid. I've searched multiple community posts and the SN wiki, but can't find a simple and clean method (as exampled above) on how to do this.
Any suggestions?
