date tables

[sakamsureshbabu]

i have date format like this

9/10/2013

4-10-2014

this two format have in my data

can i load this data to script or do you what to modify data any one format before loading. 

[#2]

Hi,

In QV, you can load what ever you want so yes you can load your date like that with different format.

If you want, you can in your request SQL use : TO_DATE(UrDate,'format') like this TO_DATE(UrDate,''yyyy/mm/dd'')

or you can in your script use : Date(UrDate).

or you can still in your script modify this line : SET DateFormat='DD/MM/YYYY';

Regards,