Hi there! Just wanted to see if anyone else was experiencing this issue / if anyone had suggestions for how to fix this? Thanks so much! Aparna

Can you post your entire JS snippet? 

Here it is – the offending line is var month = startDateJS.getMonth(); And like I said, this code was working well up until a few weeks ago; I haven’t modified anything on this page for 2 months. Thanks for your help! Aparna ------------------------------------------------------------ var field = argumentse0], value = argumentse1]; var loanModel = skuid.model.getModel(‘Loan’), firstRow = loanModel.getFirstRow(), startDate = loanModel.getFieldValue(firstRow,‘ACH_Next_Debit_Date__c’), dueDay = loanModel.getFieldValue(firstRow,‘Current_Due_Day__c’), distDate = loanModel.getFieldValue(firstRow,‘Distribution_Date__c’); var picklistEntries = field.metadata.picklistEntries; picklistEntries.length = 0; var startDateJS = skuid.time.parseSFDate(startDate); var month = startDateJS.getMonth(); var year = 1900+startDateJS.getYear(); var dueDate = new Date(year, month, dueDay); var labelDueDate = skuid.time.formatDate(“D, MM d, yy”,dueDate); var eoMonth = new Date(year, month+1, 1); var eoMonth = new Date(eoMonth-1); var labelEOMonth = skuid.time.formatDate(“D, MM d, yy”,eoMonth); var resume = false; var distDateJS = skuid.time.parseSFDate(distDate); if(eoMonth > distDateJS) { picklistEntries.push( { value: eoMonth, label: labelEOMonth, defaultValue: true, active: true } ); } for (var i=1; i<=3; i++){ month = month+1; dueDate.setMonth(month); dueDate.setDate(dueDay); dueDate.setYear(year + month/12); dueDate = new Date(dueDate); labelDueDate = skuid.time.formatDate(“D, MM d, yy”,dueDate); eoMonth = new Date(year, month+1, 1); eoMonth = new Date(eoMonth-1); labelEOMonth = skuid.time.formatDate(“D, MM d, yy”,eoMonth); resume = false; picklistEntries.push( { value: dueDate, label: labelDueDate, defaultValue: resume, active: true }, { value: eoMonth, label: labelEOMonth, defaultValue: false, active: true } ); } // Run the standard picklist renderer for the given mode skuid.ui.fieldRenderersefield.metadata.displaytype]field.mode;

Hi all - Just wanted to check again to see if anyone had thoughts about this?

Aparna,

This is probably the case, but can you check to see if ACH_Next_Debit_Date__c is a date and not a date-time object? The skuid.time.parseSFDate will fail if given a date-time, and then you’d get the error message you saw about .getMonth not being a function. You might also check the permissions associated with that field and the account object. To further investigate your problem try these steps in the developer console (if the console commands don’t work and you’re on Chrome you’ll have to switch to firefox or take away your salesforce header and footer, it’s a problem documented in this post). To get to console in Chrome right-click your page and click inspect, and to get to console in Firefox right-click and click inspect element.

date = skuid.$M(‘Loan’).data�0].ACH_Next_Debit_Date__c;

This pulls the value of ACH_Next_Debit_Date from the first row of the Loan model, and you should see a date here. The next step is

sdjs = skuid.time.parseSFDate(date);

Now you should see a more human readable form of the date. Lastly, ask for sdjs.getMonth(); and you should get a number back. These steps will help you determine if the Next_Debit_Date field has data in it and if you have access to it. Here’s a screenshot of what my console looked like after testing:

Thanks!

Amy

Thanks so much, Amy! That was really helpful - as it turns out, all of my test loans have matured, so I don’t have data in many of my fields. Fancy that! Anyways, I added a line to my code to handle the case where some of these fields are null and that solved all of my problems. Thank you again for your help!

Aparna,

Glad to hear you got it sorted out!

Thanks!
Amy