Regarding date

[nizamsha]

Hi All

i have one problem in date

i hvae a field called documentdateglpca and postingdate glpca, both of the date is in the same table say glpca..i have loaded only one table so there is no link to other table what i want exactly is i want to check the minimum and maximum date of document dateglpca..we normally use to find in this manner

min(documentdate)

max(documentdate ) usually we will find the min and max of document date or we use date(max(documentdate)),date(min(documentdate))

i want to check this min and maxdate how to check in excel or in some other manner .because i knw the mindate is 1-2-2006 and maxdate is 1-3-2011

but for me its coming in this manner mindate is 1-2-2006 and max date is 1-3-2111

can any one tell me how to crosscheck the date what i am in qvd .and also listbox  the date what its displaying

[sujeetsingh]

Just post a sample

[nizamsha]

i want to check the date what i am gettting in my listbox or table box weather is a wright date or not how to check that one

[#4]

ur question is nt clear.....

can u post the date format of the excel sheet u're using as the source of data ?

[saumyashah90]

See everything dependent on source file.

So just check the source whether in it there is some problem or not.

Just check the format while loading it in Qlikview

Put Date(Date_Field,'MM-DD-YYYY') while loading.

If this does not correct the error,it means there is some problem with your source file.

[saumyashah90]

See everything dependent on source file.

So just check the source whether in it there is some problem or not.

Just check the format while loading it in Qlikview

Put Date(Date_Field,'MM-DD-YYYY') while loading.

If this does not correct the error,it means there is some problem with your source file.

[saumyashah90]

In QlikView you can cross check by putting a text object and  in General->Text ->  =Max(Date_Field)

[nizamsha]

  THANKS sumya i have cross checked but its not working its showing only the date wht its displaying in the listbox ..wht i am asking is for eg i am hving one excel file and loading it ..in that table i have a date field we usually cross check using texbox

date(max(documentdate)),date(min(documentdate))

min(documentdate)

max(documentdate )

we  will get some date  for mini and maxi but is that the right one nu how to check ..thats my need

[saumyashah90]

Once you load.

press ctrl+t,you will get tables you have made and their linking. just right click on the table name in which dates are present and see the preview

If that date is present that mean their is nothing wrong with th qlikview.Their is surely problem in Source file from which you are making qvd.

For example:Some times it happens that in excel sheet we have dates till 2-6-11 and we get in display of qvw 2-6-1999 or 2-6-2111

Hence just check the source file.

[saumyashah90]

Also try keeping it detached i.e

=max({1}Date(Date_Field,'DD-MMM-YYYY'))