Options

To find Starting Date

sabarichandrusabarichandru Member Posts: 4
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

  • Options
    arindomarindom Member Posts: 52
    u'r requirment is not cleare please specify the senario and available field .
  • Options
    tinoruijstinoruijs 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
  • Options
    philippegirodphilippegirod 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
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    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
Sign In or Register to comment.