Can workdate be put in a column in a query?

bhagabhaga Member Posts: 1
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

  • SaouchiSaouchi Member Posts: 4
    Greetings,

    I reckon WORKDATE should do .

    Create a Codeunit file and paste in : MESSAGE('%1',WORKDATE());
  • TallyHoTallyHo Member Posts: 383
    Can't put WORKDATE in a query object
Sign In or Register to comment.