Community
Showing results for 
Search instead for 
Do you mean 
Reply

Dashboard using the SQL chart control and date formats

Bronze Contributor
Posts: 1,276
Country: USA

Dashboard using the SQL chart control and date formats

This question is to people in other timezone locations - ie where you all say express the dates backwards - yes I know you think correctly.  Chuckle.  By this I mean dd/mm/yyyy.   I have a client in Australia who is having date issues because SQL wants the dates to be mm/dd/yyyy in the Dashboard control.  I know several of my European counterparts are using the control.  Have any of you figured out a solution or workaround. 

Patricia Egen
Certified ACT! Consultant, Trainer, Developer
www.egenconsulting.com
(423) 875-2652

Follow us on:


Visit our Popular ACT Wizards Page Wizards Here!

Bronze Super Contributor
Posts: 1,231
Country: USA

Re: Dashboard using the SQL chart control and date formats

 

Pat why not use universal time in the SQL statement?

 

Date.Today.ToUniversalTime  

Date.AddMonth(1).ToUniversalTime  

 

-- Jim Durkin