Updating date field

I need to create a query which will take the date in the "First_Session_Used" and increase that date by one year, but also change it so that it is the first date in that month.

So, if the date in "First_Session_Used" is 6/7/06, the date would need to be 6/1/07 in "Scheduled_Review_Date".

If you can provide the error log I can look into it. Thanks, Kunal." id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4406312" / Hi Shaun, I think you are using Informatica cloud to push the data from oracle to SFDC. Yes, I agree that we cannot overwrite the create date field, but the field I'm talking about is called as ' Closed Date" and we are importing data from other source to Informatica. I'm trying to populate SFDC object's field with this value, but after running the Informatica, the value in closed date is system date.

Upload/Update operation in Salesforce is nothing but Upsert operation. There are no specific error log as no errors encountered.

You can create this functionality by moving the data from these field(s) to a separate related table, where the modification date field will only be updated when these fields are updated.And one more important thing, you cannot overwrite the standard date field that is "Created Date". I need to populate the closed date value from source to SFDC. We enabled the date fields to enable for update." id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4406396" / Hi Kuna, I'm not using Informatica cloud. Yes, I agree that we cannot overwrite the create date field, but the field I'm talking about is called as 'Closed Date" and we are importing data from other source to Informatica. I'm trying to populate SFDC object's field with this value, but after running the Informatica, the value in closed date is system date.If you can provide the error log I can look into it. There are no specific error log as no errors encountered. There might be some workflow active in Salesforce which is updating the " Close Date" field to system date. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions.This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi everyone, I actually have two questions I need to ask and I'll break it up so it's easier to answer.

Search for updating date field:

updating date field-49updating date field-16

Actually we have two PKs and this DATE (default getdate()) field along with other what we doing, we are inserting the records into our master table from this only unique records we are inserting.suppose sometime it may have situation like same PK but we have different date in that case we are inserting records having MAX(DATE_T) but last few months we are facing problem that same PKs and this DATE field also for accuracy purpose we need to take it 6 digit.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating date field”