Hi folks,

I'm trying to have self join on same object in SOQL Query,but did'nt work around.

I tried different queries like ,

1) SELECT Id,Name,Type
     FROM Account where Id = 'a0X3600000ACDiQEAX' IN (SELECT Type FROM Account)

2) SELECT (SELECT Type FROM Account),Id,Name,Type
    FROM Account where Id = 'a0X3600000ACDiQEAX'

Thank You.

Hi folks,

I'm trying to have self join on same object in SOQL Query,but did'nt work around.

I tried different queries like ,

1) SELECT Id,Name,Type
     FROM Account where Id = 'a0X3600000ACDiQEAX' IN (SELECT Type FROM Account)

2) SELECT (SELECT Type FROM Account),Id,Name,Type
    FROM Account where Id = 'a0X3600000ACDiQEAX'

Thank You.

This should be simple, but I'm having a hard time with it. I want to create a formula field that gives me the number of minutes between the record's CreateDate and LastModifiedDate. What does that formula need to look like?

 

Thanks for your help!

Hi,

 

I have a string, '11/20/2010 12:00:00 PM' and i would like to set this into Date format (NOT DateTime) since i want pass this value into one of my field of type date.

 

Here my function:

 

private Date setStringToDateFormat(String myDate)
    {
        String[] myDateOnly = myDate.split(' ');
        String myDateString = myDateOnly.get(0);
        String myHourString = myDateOnly.get(1);
        DateTime d = DateTime.valueOf(myDateString + ' ' + myHourString);
        return Date.valueOf(d);
    }

 

However, everytime I run this, i received an error Invalid Date/Time.

 

Could someone help???