mikemeadeuk

Hi Salathe, Excellent, thanks a lot for taking the time to help me out! Appreciate it.

I't not going to keep passing arguments back and forth. #movedon

Anyway, im off to another forum, see if anyone else can help me. thanks for your input anyway.

Hence why the world invented schools and universities. Not just throw a book at a baby and expert a Physicist in a few years.

Why, just why? Do you like being big and clever? I asked for help, tried for 3 hours, come back and said I'm still having trouble, can you help me any more please? And you get all arsey about it! Remember, im not the expert, hence why im here asking for help. It might look simple to you, and probably will to me after I figure it out, but currently I dont get it.

Hmmm, no not really. I more of a "give a man a fishing rod" kinda guy. however....something along the lines of "Yeah sure, you need to wrap your variable around this, and then do this and that. The ** means this and the ** means that. Then that should give you the kind of functionality you require. Here's a quick example to help you, this would each January." ...would have been nice!! I appreciate your help, I really do, but if I enjoyed helping people on forums and someone had a question about SEO, I wouldn't just put up a link to Google. Not whining, just need help. :-(

Hi, ok thanks. Yes I see the purple table, but just spent the last 3 hours trying to work it out. Guess I'll have to go to another forum to get help. Rather than just being redirected to a link. :-/

Hi Guys, Thanks for the replies, really appreciated. I'm having a few problems though, I can only seem to find examples that change the y/d/m around, not get the actual word like December in? or with the "th" after 13. Am I missing something? Thanks Mike

Hi Guys, Was wondering if anyone knew how to go about changing the format of a date? I have a variable which currently prints the date like this: 2012-12-13 01:01:00 But I need to change it to be displayed like this: 13th December 2012 And also like this: 63 Days left Any ideas how I would do this? Im guessing the "time left" is a little trickier, but would be great if possible? Thanks guys, really hope somone can help.

Works perfectly!! Thanks PFM, and everyone else for your help! :-)

sorry, this even: {{list ($d, $m, $y, $h, $i, $s) = sscanf({item.StartDate}, '%d/%d/%d %d:%d:%d');{item.StartDate} = date('Y-m-d H-i:s', mktime($h,$i,$s,$m,$d,$y)) ;}} This works perfectly well in a single php file, but if I put it within eval() it highlights as an error, I'm not overly clued up as you can tell, so hopefully someone can point me in the right direction. thanks

hi, it works fine in in a standalone php file yes. However I am using magento with this: http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Value_Replacer And this application uses eval() to allow php functions to alter the CSV file before importing to my magento website. This is what I did, using Barands code, and I placed it within double curly braces as the application advises. And {item.StartDate} refers to StartDate in my CSV file. {{list ($d, $m, $y, $h, $i, $s) = sscanf({item.StartDate}, '%d/%d/%d %d:%d:%d');$ymd = date('Y-m-d H-i:s', mktime($h,$i,$s,$m,$d,$y)) ;}} Any ideas what Im doing wrong? Thanks Mike

nope doesnt work. Does this work with eval()? Because this is what the software uses. thanks mike

hi sorry, just seen your reply, ill try that... thanks

Hi Barand, I did say this... Just didnt want to make a huuuuge title. sorry. Any ideas?