Hello,
I have to convert my DateofService (Datetime) to YYYY-MM, how I can do that in InDB. I know if it is in normal workflow it should be DateTimeFormat([dateofservice],"%Y-%m")
But, when using InDB, this formula isn't working.
Please help...
Solved! Go to Solution.
You need to use a SQL formula. The exact syntax varies depending on server.
For example for SQL Server:
Convert(Char(7),"DateofService",120)
should do what you want