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]

It seems that we are not able to get you if possible give a sample .

[er_mohit]

if you want to cross check date then try to use firstsortedvalue in text object

seems like

firstsortedvalue(Fieldvalue,-Date) // here fieldvalue those fieldname on the basis of max.Date it gives the value

and for min date try this

firstsortedvalue(Fieldvalue,Date) //make sure date format is same if different then try this in replace of Date

Date(date#(DateField,'DD/MM/YYYY'),'DD-MM-YYYY')  THE FIRST FORMAT IS YOUR DEFAULT AND SECOND ONE IS WHICH YOU USE

hope it helps