Date Conversions in InDatabase

[AJ-CH]

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...

[jdunkerley79 · Accepted 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