To find Starting Date

sabarichandru
sabarichandru Member Posts: 4
edited 2008-05-20 in NAV/Navision Classic Client
Hi..
i need to find the starting date of the month from the given input . can anybody help me to find out the answers .

Regards,
Sabari

Comments

  • arindom
    arindom Member Posts: 52
    u'r requirment is not cleare please specify the senario and available field .
  • tinoruijs
    tinoruijs Member Posts: 1,226
    You can use DATE2DMY and DMY2DATE for this kind of actions.
    Take a look at the function in the C/AL Symbol Menu under SYSTEM, Date and press help (F1) on the different functions to see how to use them.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • philippegirod
    philippegirod Member Posts: 191
    If you want to find the first day of the calendar month why don't you use the function CALCDATE ?
    It could be 
    FirstDay := CALCDATE('<-CM>',GivenDate);

    If you want to find the Starting Date of the Accounting Period you must use the Accounting Period table.
    My candle burns by both ends, it will not last the night,
    But oh my foes and oh my friends, it gives a lovely light
  • David_Singleton
    David_Singleton Member Posts: 5,479
    sabarichandru wrote:
    Hi..
    i need to find the starting date of the month from the given input . can anybody help me to find out the answers .

    Regards,
    Sabari

    FirstDateOfMonth := CALCDATE(MyDate,'<-CM>');

    (or something like that)
    David Singleton

Categories