Hi All
I have a date that I'm reading in from an email input, stripping the rest of the email from around it and trimming out spaces. Cecause the date has come from an email it is in string format and I have placed the output from the trim etc in to a string field (New Contractor End Date Text field in the screen shot below). As its from a user input it could be in any format.
What I need to do is convert that string date in the field New Contractor End Date Text in to an actual date in the right format (ServiceNow format) and output to the field New Contractor End Date.
I've tried a few GlideDate scripts but nothing seems to be working for me. I've also read about Date Parse, but unsure if I need to use that.
Here is my last script:
var date = 'new_cont_end_date_text';
var simpleDateFormat = 'dd-mm-yyyy'; // Simple Date Time format
var gdt = new GlideDate();
gdt.setDisplayValue(date,simpleDateFormat);
gs.addInfoMessage(gdt.getDisplayValue());
u_new_contractor_end_date = setValue.gdt.getDate();
Can someone help me as to where I'm going wrong and am I making this more complicated than it needs to be?
Thanks in advance.
