FORMAT SALESFORCE DATE TIME FIELDS IN EXCEL | Techila
2090
single,single-post,postid-2090,single-format-standard,ajax_updown_fade,page_not_loaded,,qode_grid_1300,footer_responsive_adv,hide_top_bar_on_mobile_header,qode-content-sidebar-responsive,qode-theme-ver-9.4.2,bridge,wpb-js-composer js-comp-ver-4.12,vc_responsive
 

FORMAT SALESFORCE DATE TIME FIELDS IN EXCEL

FORMAT SALESFORCE DATE TIME FIELDS IN EXCEL

FORMAT SALESFORCE DATE TIME FIELDS IN EXCEL

So, I did a data export from salesforce.com and wanted to get the month from a date time field.

The general format of DateTime fields is like this 2012-01-15T18:34:00.000Z

If suppose you have this in column D in excel, just type in the following formula in an adjacent column

Say you do it in E1

=SUBSTITUTE(SUBSTITUTE(D1,”T”,” “),”.000Z”,””)

This eliminates the time part and you just get the date value.

Now, simply double-click on the bottom edge of E1 and the formula would be applied to the entire column E.

Now, E might still represent some number. Select the entire E column, right click and select “Format Cells” and select the category as “Date”.

To fetch the Day, Month and Year from column E, use the formulas = DAY(E1), =MONTH(E1), =YEAR(E1).

Courtesy:  http://www.forcetree.com/2012/02/format-salesforce-date-time-fields-in.html
https://cdn2.iconfinder.com/data/icons/staff-management/512/datetime-512.png

“Explore – Techila Global Services, A Salesforce development company”

Author: techila

No Comments

Post A Comment