Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Date(date,'YYYY-MM-DD')
You can use date# function
Try:
Date(Date#([your date field]),'YYYY-MM-DD')
Regards
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