Forum Discussion
AmandeepDhillon
4 years agoQrew Member
Hi Mark
Thanks for your response.
The first solution has error- Cannot use "-" operator on types text.
whereas with second solution result is dd-mm-yyyy and blank fields as 00-00 whereas my specific requirement is dd/mm/yyyy
Please help.
------------------------------
Amandeep Dhillon
------------------------------
Thanks for your response.
The first solution has error- Cannot use "-" operator on types text.
whereas with second solution result is dd-mm-yyyy and blank fields as 00-00 whereas my specific requirement is dd/mm/yyyy
Please help.
------------------------------
Amandeep Dhillon
------------------------------
MarkShnier__You
Qrew Legend
4 years agoTry 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
------------------------------
- AmandeepDhillon4 years agoQrew Member
Hi Mark
It worked perfectly fine.Appreciate your help.
------------------------------
Amandeep Dhillon
------------------------------