[SalesForce] Datetime parsing

     String date = '';
     String time = '';

How to concatenate the two strings to StartDatetime(Datetime datatype) field?

I am using two strings date and time seperately ,If i fill date & time then i want to combine the two fields and store in one field (i.e) Startdatetime__c (Datatype as DateTime) how to fix this one?

This is my REST request { "sdate" : "2/12/2013", "stime" : "12:05:00" }. How do I convert the sdate & stime into a DateTime field StartDatetime__c?

Best Answer

Here's an example from some code I used in a trigger on how to do this

StrtTmDt = sClsMnth + '/' + sClsDay + '/' + sClsYear + ' ' + strtTm;

So, in your case,

String date = ''; //would need to be formatted as 'dd/mm/yy'

String time = ''; //would need to be formatted as ' hh:mm aa` where aa is AM or PM

note the blank space between the ' and the hh. You need this separation. SF will automatically add :00 seconds for you so there's no need to add them unless you actually are recording seconds or microseconds for that matter.

If properly formatted as above, you could then do the following:

String dt = date + time;

DtTm = DateTime.parse(dt);

Related Solutions

[SalesForce] How to convert date string to DateTime type without GMT

Looks like DateTime.parse() takes the string and parses it based on the context users locale to produce a GMT date/time in the database. DateTime.format(String) should create an output string in based on the timezone of the current context user.

So you should be able to use when data comes in:

DateTime dt = DateTime.parse('11/6/2014 12:00 AM');

Then when you go to call the web service you'd use something like:

String dtOut = dt.format('d/M/y'); -- Or M/d/y if you're using American dates.

And for the bonus, you could just use a different argument in the format function such as:

String timOut = dt.format('h:m a');

[SalesForce] Combine Date from one datetime field with Time from another

You want to use the Datetime.newInstance method with parameters Date, Time.

Datetime withDate; // e.g. 2014-08-13 00:00:00
Datetime withTime; // e.g. 1899-12-30 15:38:19

Datetime withBoth = Datetime.newInstance(withDate.date(), withTime.time());

If you wanted to preserve GMT (doesn't sound that way) you could use withTime.timeGMT().

Best Answer

Related Solutions

[SalesForce] How to convert date string to DateTime type without GMT

[SalesForce] Combine Date from one datetime field with Time from another

Related Topic