Date Time

Hi,

I have a Database (MSSQL) with some tables having multiple Time columns (which I imported from some Access DB).

The DateTime format in the MSSQL is format. I populate my web forms using these columns (start time etc.) My problem is I cannot seem to add subtract time. I only need time part and I can use TimeFormat() function but I cannot seem to add time.

Can coldfusion deal with this format?

Thanks.

re: Date Time

Use the DateAdd function to add/subtract date/time.

re: Date Time

Awesome! Thanks a lot.

re: Date Time

You're welcome.