You need to sign in to do that
Don't have an account?
dlutchner
Date format dd-mm-yyyy turning into mm-dd-yyyy
I am running 6.16pe. In Excel my date is showing in format dd/mm/yyyy however when I upload to S.F. it changes to mm/dd/yyyy. Am I doing something wrong?
thanks
Be carefull
In earlier versions of Excel Connector ( I think it's fixed now but I haven't tried) if you have Eurpean locale Excel (dd/mm/yyyy) if you round trip a date i.e.
Read from Salesforce into Excel
Excel to Salesforce
the date (if before the 12th of the month) can insert into salesforce.com with the days and months reversed. If you then re-round-trip it you will set it back to normal.
See Earlier Post
Watch out.
Gareth.
I'm not too happy with the date issues in salesforce. I've been copying the dates from excel into a file and running sed on it.
cat dates.txt | sed -e "s/ .*//" | sed -e "s/\/\([0-9]\)\//\/0\1\//" | sed -e "s/^\([0-9 \/]\{9\}\)$/0\1/" | sed 's/\///g' | sed -e"s_\(..\)\(..\)\(....\)_\3/\2/\1_p" | sed "s/\//\-/g"
So it takes 01/04/2008 00:34 chops/converts into 2008-04-01
Dont get me started with working with openoffice.org!
Or using AWK,Turns “19/04/2007 20:35” into 2007-04-19
awk -F "\/" '/ *[0-9]+\/[0-9]+\/[0-9][0-9][0-9][0-9]/ { printf "%04d-%02d-%02d\n",$3,$2,$1 }'
Change the language and the format should be the same as in your excel.
Here in México we use dd/mm/yyyy
but when i'm working with english version of salesforce it always changes the date to mm/dd/yyyy
also you can separate the date in year, month and day and put them in the order you want, whatever it is, try convert every part into a string and change the order.