Skip to Content (Press Enter)
2020-06-26 10-11-24
kan2332
96Views
8Comments
How to write correct code (syntax)
Question
Traditional Web
Development
Application Type
Traditional Web
NewDate( Year(CurrDate), Month(CurrDate), 1), AddMonths(NewDate(Year(CurrDate()),Month(CurrDate()),1),-1)

How to correct write (i have syntax error)

0
0
11 Nov 2020
Copy Link
2020-04-15 19-07-26
Eduardo Rodrigues

Hi, 

Can you explain what you want with this function?

Best regards,

Eduardo

0
0
11 Nov 2020
Copy Link
2020-06-26 10-11-24
kan2332

I wish that I could take any date and download the last month's report

0
0
11 Nov 2020
Copy Link
2020-04-15 19-07-26
Eduardo Rodrigues

Because you have a comma, right after the first NewDate () function, which shouldn't exist.

0
0
11 Nov 2020
Copy Link
2020-04-17 08-41-30
Tim Timperman

The result of the code you have now, is 2 dates, separated by a space. This is not valid.

If the result you need is the first day of the previous month, then just remove everything before "AddMonths".

0
0
12 Nov 2020
Copy Link
2020-04-15 19-07-26
Eduardo Rodrigues

Maybe this:

AddMonth(InputDate,-1)<=DateReport and 

DateReport <=InputDate


0
0
11 Nov 2020
Copy Link
2020-04-15 19-07-26
Eduardo Rodrigues

Or you should separate this funciton into two assigns. 

Begin date: 

NewDate( Year(CurrDate), Month(CurrDate), 1)

End date:

AddMonths(NewDate(Year(CurrDate()),Month(CurrDate()),1),-1)
0
0
11 Nov 2020
Copy Link
2020-06-04 15-38-19
Samiksha Manekar

Hi kan,

  Substr(AddMonths(#2020-11-1#,1),9,9) = 1
Put this condition in "IF".
Hope this Helps.

Thanks

Samiksha

0
1
11 Nov 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.