Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in the source database- we have 1 field with date and time.
In script I try to make form this field 2 fileds - 1- date and 2- time,
but the proble is that QV creates from 1 to 8 same values of date.
for example many values of 31.08.2011
how to tell QV to make only 1 date value for all data with the same date?
Dmitry,
I do not open attchements, so the following is just my guess.
If you have two values:
Oct 28 2011 10:30
Oct 28 2011 10:40
And, you format it as date:
date(<datetimefield>)
You get two "values of the same date" because the undelying data is different. To make it "real" date, you have to use integer part of your field as date, and fraction part as time:
date(floor(<datetimefield>)) as Date
time(frac(<datetimefield>)) as Time
Dmitry,
I do not open attchements, so the following is just my guess.
If you have two values:
Oct 28 2011 10:30
Oct 28 2011 10:40
And, you format it as date:
date(<datetimefield>)
You get two "values of the same date" because the undelying data is different. To make it "real" date, you have to use integer part of your field as date, and fraction part as time:
date(floor(<datetimefield>)) as Date
time(frac(<datetimefield>)) as Time
Great thanks