Date Problem Formule

Resolved

(@klingbeil)

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)

← 1 2

Plugin Author codepeople
(@codepeople)

2 years, 6 months ago

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)

2 years, 6 months ago

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)

2 years, 6 months ago

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)

2 years, 6 months ago
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)

2 years, 6 months ago

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)

2 years, 6 months ago
```
@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;"></td><td style="text-align: right;"><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 2 years, 6 months ago by klingbeil.
Plugin Author codepeople
(@codepeople)

2 years, 6 months ago
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)

2 years, 6 months ago

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)

← 1 2

The topic ‘Date Problem Formule’ is closed to new replies.