How to change the date format in QV?

[#1]

I've a table from which a date value is fetched in the format 'mm/dd/yyyy'. I've stored this value in a variable and want to change the format to 'yyyy-mm-dd' to pass it to some other SQL.

Please help.

[#2]

Try this:

Date(date,'YYYY-MM-DD')

[#3]

You can use date# function

[#4]

Try:

Date(Date#([your date field]),'YYYY-MM-DD')

Regards

[nirav_bhimani]

Hi,

One more alternative is Go to...........

Setting-> Document Property ->Number->Select Filed->Select Number format setting = Date ->apply your Format pattern like 'YYYY-MM-DD'.

Regards,

Nirav Bhimani