I have a script where I upload my excel file and read it using pb script
On my excel file this is how I display my date : WEDNESDAY, JANUARY 1, 2020
And this how I read it
s_logdte = trim(string(myoleobject.application.workbooks(1).worksheets(1).cells(3,5).value))
s_logdte = mid(s_logdte,11,40)
dt_date = datetime(date(s_logdte))
But i'm having trouble on how will I trim the date to only DATE without the DAYNAME
I have attached a screenshot for your reference.