We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Conversions in InDatabase

AJ-CH
8 - Asteroid

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

1 REPLY 1
jdunkerley79
ACE Emeritus
ACE Emeritus

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

Labels
Top Solution Authors