1-1-1970 Paydays
Hello, trying to populate paydays and using the following formula but its returning 1-1-1970 no matter how I rework it. Was trying to work through pay periods of the 1st through the 15th is paid on t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
var number DayOfMonth = Day([Pay Approved]);
var number MM = Month([Pay Approved]);
var number YYYY = Year([Pay Approved]);
Date($YYYY, $MM & If($DayOfMonth <10,10,25) & $DayOfMonth)
Here is the syntax help. its YYYY, MM, DD syntax
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=7&rl=wc
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var number DayOfMonth = Day([Pay Approved]);
var number MM = Month([Pay Approved]);
var number YYYY = Year([Pay Approved]);
Date($YYYY, $MM & If($DayOfMonth <10,10,25) & $DayOfMonth)
Here is the syntax help. its YYYY, MM, DD syntax
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=7&rl=wc
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
