QV

[#1]

Hi,

If we create in the script floor(date) it will display in interger form if we don't have that date in table. otherwise will it display as date( same as from date in table). can anyone clarify my doubt as I strucked here to procced further.

[#2]

are you using floor function as shown below?

Date( Floor( Date ), 'YYYY-MM-DD') as Date

[#3]

Hi,

The floor function used  in QVD is:

Floor(date(date,'dd/mm/yyyy') as date

whereas the floor function used in live file is :

Floor(date) as date

In the live file in one table the date is taken as using floor function. And upto last month the data is fine in the file but I am nit able to see the data since last month.

urgently needed

[Anonymous]

In both cases Floor() is outsede, hence it is creating integer format.  To get date format, it should be

date(floor(date))

If you want to specify format, it will be:

date(floor(date), 'dd/mm/yyyy')

[#5]

Hi,

Means it should be like

date(floor(createdon), 'dd/mm/yyyy')

Is it right? actually my field is createdon instead of date

please consider as urgent

On Wed, Jun 19, 2013 at 6:39 PM, Michael Solomovich <

[narender123]

Yes .You are right .Date field name is anything as you said, it is "createdon" then you can make the date as you have shown above.

So go and proceed with the same as you have written.

Thanks.

John

[#7]

Hi John,

here I have one query.

as we are getting data upto april but from may onwards we are not able to see any data? as I observed and try to change the SQl table from old database to new database and try to reload the QVD first but surprisingly it is not allowing me to reload. Can you tell me what could be the reason?

[narender123]

As you are getting the data up to April it means that  upto april date data is present and after your qvd refresh its upto april data.Now you have converted  into new sql table so means that only changes in table .

I think the problem is in your table name that you have modify as table.

For this either you have to ignore only that table by comment it or by delete from your Qvd fileas  and again reload qvd.after this if it working fine that means the problem is with new table that you modified .

Thanks

[narender123]

You also have to keep in mind that the table that you have converted ,again take that table from sql db and delete the previous one from your qvd.means create new QVD for that table.

Thanks

[#10]

I was trying to reload entirely in different fiolder by taking the same QVD. but I changed the sql table, because the table name is same but the database is changed from old to new. now I need to use the table which exists in new database. even I tried by deleting the QVD also none is working.