Forum Discussion

FML's avatar
FML
Regular Visitor
1 year ago
Solved

Startofmonth() in Virtual Table

buen día, no puedo utilizar la función Startofmonth() con una columna de una tabla virtual, generada mediante crossjoin. Me pueden ayudar por favor ? gracias    
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Trying using this instead

     

    Eomonth( [value], -1) + 1

FML's avatar
FML
Regular Visitor
1 year ago

thanks for for answer, but it doesn't work !

 

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

    Trying using this instead

     

    Eomonth( [value], -1) + 1

    • FML's avatar
      FML
      Regular Visitor
      1 year ago

      Excellent Deku !!!! it works !!!

      Can you explain me how it works and why endofmonth doesn´t ?

      • Deku's avatar
        Deku
        Icon for Super User rankSuper User
        1 year ago

        The time intelligence functions are funny and I try to stay away from them.

         

        Alot of info here