First of the Month formula

[Prognewb]

This is probably very simple... on a report I have a Start Date and End Date (prompts), and need to create a formula that finds the first of the month of the End Date. I'm pretty sure either DateDiff or DatePart is what I need, but not sure where to go from there.

Example:
Start Date = 5/14/06
End Date = 6/14/06
First of the Month = 6/1/06

Any help to get me started would be greatly appreciated.

 

[lbass]

Try:

{?EndDate}-day({?EndDate})+1

-LB

 

[Prognewb]

That works! Thank you!

 

[fcullari]

I have a data field that has a string of numbers, I want to have each number list separately, and be able to sort by those numbers.


Example of data field:
0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444

I want to see my numbers in my report as a column:
0458
0470
08058
08161
08845
28845
41319
41329
41330
44154
etc

Please help!

 

[lbass]

Please start a new thread, as your topic is entirely different.

-LB