Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DateAdd

Good morning,

I want to add 1 month to my column "birthday date" so I tried to use the function DateAdd but I got blank space for some value in my new column. Indeed I see in internet that it only work if the date calculated is already in my column "birthday date". Do you know how can I do to still have my columns with birthday date +1 month even if it's not contains in my "birthday date"?

Thank you!

Best regards

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found a solution, I use the founction EDATE(date,nbreofmonth) and it works perfectly

    Thank you

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    what should it show if there is no birthday date?

     

    Best regards

    Denis

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello selimovd , normally there are always a birthday date but if it's not the case maybe a blank or a 0 ?

      Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I found a solution, I use the founction EDATE(date,nbreofmonth) and it works perfectly

    Thank you