SQL - "CreateDate" function

Comments

2 comments

  • Avatar
    Hamza Jap-Tjong

    Hi Marco,

    If you want to use a field as a date(time) field in Sisense, then it needs to be a correct date-variable (if im not mistaken). So in your case it would be :

    CreateDate([Years],[Months],01)

    You need to add the day to make it a correct date-field. On the front-end of Sisense you can format a date-field to only show MM/YYYY

    0
    Comment actions Permalink
  • Avatar
    Marco R

    Hi Hamza !

    Thank you for your reply ! It's working now. Actually, I only had to add the day.

    Thanks a lot for your help !

     

    0
    Comment actions Permalink

Please sign in to leave a comment.