AmandeepDhillon
4 years agoQrew Member
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([Last Drop Status Change Date]),2),
"01","01","02","02","03","03","04","04","05",
"05","06","06","07","07","08","08","09","09",
"10","10","11","11","12","12")& "/"
& Right(ToText([Last Drop Status Change Date]),"-")
My issue is that it works on all the fields that have date values but with blank fields it returns the value"/ /".
Can someone help me in figuring this out. I was thinking of using IF and else with this formula but its not compatible.
I would appreciate all the help and insights.
------------------------------
Amandeep Dhillon
------------------------------
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([Last Drop Status Change Date]),2),
"01","01","02","02","03","03","04","04","05",
"05","06","06","07","07","08","08","09","09",
"10","10","11","11","12","12")& "/"
& Right(ToText([Last Drop Status Change Date]),"-")
My issue is that it works on all the fields that have date values but with blank fields it returns the value"/ /".
Can someone help me in figuring this out. I was thinking of using IF and else with this formula but its not compatible.
I would appreciate all the help and insights.
------------------------------
Amandeep Dhillon
------------------------------