Can workdate be put in a column in a query?

bhaga
bhaga Member Posts: 1
in NAV Tips & Tricks
Is there a way to have a column in a query that contains the location workdate? I am using Dynamics 2019 Business Central. Right now I am linking the Base Calendar Change and Location table and grabbing the Date field from the Base Calendar Change table. I was hoping for a more elegant solution. Pretty new to this so I'm sorry if this is a stupid question. I would appreciate any help I could get.

Answers

  • Saouchi
    Saouchi Member Posts: 4
    Greetings,

    I reckon WORKDATE should do .

    Create a Codeunit file and paste in : MESSAGE('%1',WORKDATE());
  • TallyHo
    TallyHo Member Posts: 417
    Can't put WORKDATE in a query object

Categories