Converting Date From mm-dd-yyyy to dd/mm/yyyy
Hello I am trying to convert the date from mm-dd-yyyy to dd/mm/yyyy and i have used following formula Left(NotLeft(ToText([Last Drop Status Change Date]),"-"),"-")& "/" & Case(Left(ToText([L...
Forum Discussion
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
Qrew LegendTry 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
------------------------------
Hi Mark
It worked perfectly fine.Appreciate your help.
------------------------------
Amandeep Dhillon
------------------------------