Dates are showing incorrect

[#1]

Hi,

I have a list box with Date. The values are showing fine upto 2013/09/28 but afterwards yit is showing 41564.44683923 and so on.

again after 41564.------  it is showing multiple times the below dates

2013/09/30, 2013/10/01

Could anyone let me know why it is happening.

Thanks.

[#2]

U can send me data

[jagan]

Hi,

In Date List box use the following expression instead of Date Field, that decimal values are time part

Date(Floor(Num(DateFieldName)))

Or

You can do the same in script also.

Regards,

Jagan.

[v_iyyappan]

Hi,

do u check the dateformat in script like  YYYY/MM/DD ? date is load from excel file or any external files we need to check the dateformat like

Date(Floor(Date#(datefield, 'YYYY/MM/DD'))) as Datefield

regards,

[Gysbert_Wassenaar]

Use the floor function to cut of the time parts in the script: floor(MyDate) as MyDate. If necesarry use the date() function to add a format: date(floor(MyDate),'YYYY/MM/DD') as MyDate. Replace MyDate with the name of your date field.

[#6]

Thanks but now I can able to see one value as 41564.------ and also I am not I am not getting expected data based on selections i,e the values are not cahnging. I attached Link table which I used please let me know do I need to make any changes in Link table.

please have a look on attached

[saumyashah90]

1)Go to Settings->Document Properties->Number->click on the field name and click on date on the right for the format.

2)Also go to the Object ,right click for properties->Number->again choose the field or expression name and change the format on right clicking on Date.

3)When you are loading that field in script take Date(Floor(DateField),'YYYY/MM/DD') as DateField. and then reload.

4)If still the problem persist then the format of the source from where it is coming is text format, need to change it in source file.

[jagan]

Hi,

If you are joining the tables based on date then you need to convert the date which you are doing in the  Link table also, then only the two tables correctly join.

Regards,

Jagan.

[#9]

Hi,

But I convert the date field in Loader qvd. from Loader qvd I used the date field in Link table. so, in this case do i need to convert in all tables which is coming from loader. please help me in this.

Thanks.

[saumyashah90]

yes you need to convert it on all the qvd's which you are using it