Date Problem Formule

  • Resolved klingbeil

    (@klingbeil)


    1 year ago

    Hi

    fieldname 14 : Start Date
    fieldname 15 : End Date
    It expresses.

    My 1st question = Printing error message if fieldname 14 field is greater than fieldname 15 field.

    My 2nd question: How do we calculate business days NETWORKDAYS by adding the number of days from the start date (fieldname24) to the criterion = (fieldname 23 === ‘B’)?
    Can you help me complete the formula?

    (function() {
  var kriter3;
  if (DATEOBJ(fieldname14, 'dd/mm/yyyy').getTime() > DATEOBJ(fieldname15, 'dd/mm/yyyy').getTime()) {  
    jQuery('#calculation-kriter3').html('Se?ilen tarih ileri bir tarihdir.');
    return 'Se?ilen tarih ileri bir tarihdir.';
  } else {
  if (fieldname23 === 'A') {  
    kriter3 = NETWORKDAYS(fieldname15, fieldname14, "dd/mm/yyyy");
    jQuery('#calculation-kriter3').html(kriter3);
    jQuery('.kriter3-aciklama').html('?? Günü Say?s? : ');
    jQuery('.kriter3-sonuc').html(kriter3 + ' gün');
  
  } 
  if (fieldname23 === 'B') {
    kriter3 = DATETIMESUM(fieldname14, 'dd/mm/yyyy', fieldname24, 'd');
    jQuery('#calculation-kriter3').html(kriter3);
    jQuery('.kriter3-aciklama').html('?? Günü Sonras? Tarih : ');
    jQuery('.kriter3-sonuc').html(kriter3);
  } 
  
  return [kriter3];
})();

Viewing 8 replies - 16 through 23 (of 23 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @klingbeil,

    Yes, that’s possible. Please read the Date/Time operations module:

    https://cff.dwbooster.com/documentation#datetime-module

    And pay special attention to the WEEKDAYNAME operation.

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    Hello;
    I looked at that Part but I want exactly this.
    For example, the names of the days between April 20-25;
    abbreviated side by side
    I couldn’t find how to do it as (Fri.Sat.Sun.Sun).
    I would be happy if you help.

    Plugin Author codepeople

    (@codepeople)

    Hello @klingbeil

    In this case, you can make a plain object with days numbers as property names and the text you want to display as property values, and then use the WEEKDAY operation as the property name to get the corresponding value.

    If you need its implementation as an operation you can call from different equations on your form, you can contact us directly through the plugin website: Contact Us

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    First of all, I did not run a contrary command in this date calculation, but I am getting this error. I wanted to inform you that it may be related to the plugin.

    My second question is, if I make the results on mobile 10px, both desktop and mobile are 10px. I wonder if my mobile view criteria are wrong?
    thanks.

    @media (max-width:710px){
.cff-form{min-height:785px;} /* Mobil Boyut */
}
    .mobile-sonuc {
		font-size: 14px;
		color: #ff6605;
	}
	    .mobile-aciklama {
		font-size: 14px;
		color: #000000;
	}
    Plugin Author codepeople

    (@codepeople)

    Hello @klingbeil,

    The error message indicates you are trying to assign a value to a non-existing field.

    And for your second question, if you want to apply a min-height to an element in HTML, it must have assigned display: block; or display:inline-block;

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    @media (max-width:710px){
.cff-form{min-height:785px; display: block;} /* Mobil Boyut */
}
    .mobile-sonuc {
		font-size: 10px;
		color: #ff6605;
	}
	    .mobile-aciklama {
		font-size: 10px;
		color: #000000;
	}

    Now that I couldn’t explain it fully, I’ll write it again.
    I want the font size of the results section to be 10px on the mobile version of the site, but it should still run at 14px on the desktop.
    For this 

    @media (max-width:710px){

    I added the field and defined the mobile-result and mobile-description tag values in the result section.

    	    <td style="text-align: left;"><b class="kriter9-aciklama mobile-aciklama"></b></td><td style="text-align: right;"><b><span data-cff-field="fieldname999"class="kriter9-sonuc mobile-sonuc" style="color:#ff6504;"></span></b><text style="color:#ff6504;"> </text></td>


    But when I make it 10px, it becomes 10px on both mobile and desktop.
    I also added a display block, is that correct?

    • This reply was modified 1 year ago by klingbeil.
    Plugin Author codepeople

    (@codepeople)

    Hello @klingbeil

    You are closing the @media section too soon.

    @media (max-width:710px){
    .cff-form{min-height:785px; display: block;} 
    .mobile-sonuc {
        font-size: 10px !important;
        color: #ff6605;
    }
    .mobile-aciklama {
        font-size: 10px !important;
        color: #000000;
    }
}

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    Thank you very much, I have never seen a support line that is as knowledgeable and supportive of its plugin as yours. Perfect

Viewing 8 replies - 16 through 23 (of 23 total)
  • The topic ‘Date Problem Formule’ is closed to new replies.