Multiply Value To Number of Days (1 Viewer)

vagues0ul

Registered User.
Local time
Today, 13:37
Joined
Sep 13, 2018
Messages
103
I want to achieve a task of multiplying a number to specific number of days based on criteria.

If the current date is more than required date. then multiply a specific value to those number of days and return a value.

due date = 22-Oct-2018
current date = 27-Oct-2018
late date charge = 5 * 150 = 750

where 5 is number of days between due date and current date.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:37
Joined
Aug 30, 2003
Messages
36,118
You can use the DateDiff() function to calculate the number of days between the 2 dates. Depending on your needs, I might create a public function you pass the 2 dates to and it would calculate and return the amount (0 if appropriate).
 

Users who are viewing this thread

Top Bottom