[progress Communities] [progress Openedge Abl] Forum Post: Re: 4.0.4 - Select Query With A...

  • Thread starter Thread starter Meryk
  • Start date Start date
Status
Not open for further replies.
M

Meryk

Guest
Hi Shiva, Thanks for the reply. it is working. Now I am trying to convert the 'dateVar' to UTC date, before formatting it. Basically I am doing this select Query on an external table, that has a date column stored in UTC format, and it will always be the case. Whereas the Date that will come form a datePikcer form the page will have the user local time (or whatever the user is setting in the preferences). In my case it is BST Time, but can be IST or US TIME). So I need to convert the Date I get from the datepicker : 'dateVar', to UTC, then format it and do the query. What is the best way to do this please? Thank you Meryem

Continue reading...
 
Status
Not open for further replies.
Back
Top