Date Formatting
Hi,
My database requires SQL dates to be formatted as 'YYYY-MM-DD' and the
search criteria requires that a date be entered in the windows default
format. Report builder is formatting the dates for SQL in the same
format as entered. What do I need to set in code to have RB format the
dates in the 'YYYY-MM-DD' format for the SQL statement to work? I have
rb 55 right now, but will download version 6 if necessary.
Thanks,
Sean
My database requires SQL dates to be formatted as 'YYYY-MM-DD' and the
search criteria requires that a date be entered in the windows default
format. Report builder is formatting the dates for SQL in the same
format as entered. What do I need to set in code to have RB format the
dates in the 'YYYY-MM-DD' format for the SQL statement to work? I have
rb 55 right now, but will download version 6 if necessary.
Thanks,
Sean
This discussion has been closed.
Comments
see my reply on DBISAM NG
Jon