Jeff S
asked on
Crystal Reports - help with converting time in a formula
I am trying to convert a date field to Spanish and having issues with the cast of the time. I need the time to return as 9:00 AM and I am getting this:
3 de marzo, 2017 9.00:0.00
My formula:
StringVar Array Months := ["enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre"];
ToText(Day({cus_futureAppt s.ApptStar t}),0) + " de " + Months[Month({cus_futureAp pts.ApptSt art})] + ", " + ToText(Year({cus_futureApp ts.ApptSta rt}),0,"") + " " + ToText(Hour({cus_futureApp ts.ApptSta rt})) + ":" + ToText(MINUTE({cus_futureA ppts.ApptS tart}))
3 de marzo, 2017 9.00:0.00
My formula:
StringVar Array Months := ["enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre"];
ToText(Day({cus_futureAppt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Splitting points to stay fair as both came in at same time and both worked.
pls try
Open in new window
Regards