Separate Date from Time

[#1]

Dear All

I am a new user and I need your help for a rather easy ( for you ) problem.

I want to separate date from time.

In the past I was doing something like this :

Date (DateTime,'dd/mm/yyyy') As ShortDate

But now I can't find the date function. I am using the Version 9.00.7469.8 SR4.

Thank you very much

Kostas Stathis ( k.stathis@live.com )

[#2 · Accepted solution]

Hi Kostas,

You can try the below. If you can send some examples of App_Date field from your SQL database, we can guide you better.

makedate(year(App_Date), month(App_Date), day(App_Date)) as ShortDate

Regards,

Sajeevan

[#3]

Dear Sajeevan

Your suggestion works perfectly. The DB is an Access it is not SQL. With SQL I have no problem and I use the Date  function. I am not sure yet what is going wrong. I am looking the regional settings of the PC ,there was a difference with the date format in QV ( but the problem is not solved using the date function ). I didn't send you a sample because it is in Greek.

Thank you very much

Kostas

[#4]

Hi Kostas,

Thanks. I have couple of Greek colleagues and one of the colleague's name is also Kostas hence it is not a problem even if the data is in Greek.

Best Regards,

Sajeevan