Forum Discussion
MarkShnier__You
Qrew Legend
Try this
var text Result = List("/",
PadLeft(ToText(Day([Last Drop Status Change Date])),2,"0"),
PadLeft(ToText(Month([Last Drop Status Change Date])),2,"0"),
ToText(Year([Last Drop Status Change Date])));
If(not IsNull([Last Drop Status Change Date]), $Result)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text Result = List("/",
PadLeft(ToText(Day([Last Drop Status Change Date])),2,"0"),
PadLeft(ToText(Month([Last Drop Status Change Date])),2,"0"),
ToText(Year([Last Drop Status Change Date])));
If(not IsNull([Last Drop Status Change Date]), $Result)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
AmandeepDhillon
3 years agoQrew Member
Hi Mark
It worked perfectly fine.
Appreciate your help.
------------------------------
Amandeep Dhillon
------------------------------