# Storing datetime using transaction groups **URL:** \ **Category:** Ignition\ **Created:** [April 23, 2012, 2:11pm UTC](https://forum.inductiveautomation.com/t/storing-datetime-using-transaction-groups/4334 "2012-04-23T14:11:45Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![dfenter](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Post date:** [April 23, 2012, 2:11pm UTC](https://forum.inductiveautomation.com/t/storing-datetime-using-transaction-groups/4334/1 "2012-04-23T14:11:45Z")
I have a set of tags that perform a calculation that return a datetime. I would like to use a transaction group to store these datetimes to a table, then use the data from the table as a binding property to display the events on a calendar. When I try to set up the transaction group to save the datetimes to a table in my MSSQL database, I keep getting error saying: Error forwarding data: implicit conversion from data type datetime is not allowed. Use the CONVERT function to run this query. I have also tried formatting the tags as strings, and in that case I get the error: Error forwarding data: conversion failed when converting nvarchar value “2012-04-23 10:48:21” to data type int. So my question is, what would be the best way to set up the group of tags as events on a calendar? Should I use the transaction group? If so, how do I get the datetimes to save to the database?? Dan ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [April 23, 2012, 3:55pm UTC](https://forum.inductiveautomation.com/t/storing-datetime-using-transaction-groups/4334/2 "2012-04-23T15:55:08Z")
It sounds like the column you are trying to write to in MSSQL is an integer. Why are you trying to put a date into an int field? Maybe you have the wrong column name?