Hi ... extremely new to Unix scripting ... I have to get a date field from mm/dd/yyyy to yyyy/mm/dd format ... I have a variable that I want parsed. I don't seem to be doing it right?? Thanks.
My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in function like =text(,"") but it did not work, I still got the same format. I also looked for questions in Super User stack and google but I could not find solution. Please help. Thanks for your input.
I want to automate change in 'from yyyy/mm/dd to yyyy/mm/dd' every month in a unix program.
For example in this month 'from yyyy/mm/dd to yyyy/mm/dd' is 'from 2014/10/01 to 2014/11/01' next month it should be 'from 2014/11/01 to 2014/12/01'
Can any one provide me the code for the above automation process plzz...
I have a number of files that contain the date in the following format: dd-mm-yyyy, I'd like to change the date part in the name to a different format: yyyy-mm-dd.
Any ideas? I'm no expert in different shell engines, can dos do the trick?
I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type value as *14-03-01 and changed the date format to DD-MM-YY. Now the date in the cell looks as per the selected date format. Now what I want is to use the same date format into formula bar too.
Ok...this is really bumming me out because it seems like it should be simple, but for some reason, I just can't get it...I've also googled and searched these forums, and haven't found exactly what I'm looking for...
I have a date in mm/dd/yyyy format in a variable...I need to extract the abbreviated name of the day of week from that variable...so I start with this: