1 2 Previous Next 19 Replies Latest reply on Jul 1, 2016 1:00 PM by hellkay

    current month field?

    hellkay

      I though this would be easy, but I can't find a way to get(currentDate) for just the month?

        • 1. Re: current month field?
          karina

          Hi,

          You can use:

          Month (Get ( CurrentDate ))

          • 2. Re: current month field?
            Benjamin Fehr

            If it's for layout use only, you can specify with the Inspector.

            Bildschirmfoto 2016-06-14 um 23.45.18.png

            • 3. Re: current month field?
              hellkay

              I actually need to use it for a report: current month, month plus 1, month plus 2.

              I have two tables of data (open purchase orders and open customer orders) which I need to total by item code for current month, next month and two months from current month.

              I was hoping for it to populated automatically from the Get(currentdate) field, but when I do the calc as Month(Get(CurrentDate)) it's not displaying properly...maybe it's a layout thing like you suggested.

              I will check it again tomorrow (east coast time)   thanks for your help!

              • 4. Re: current month field?
                karina

                Hi,

                Did you set your calculationresult to number?

                Because when it's only the month the result isn't a date but a number.

                • 5. Re: current month field?
                  StephenWonfor

                  Hi

                   

                  When dealing with dates I find this sort of thing very, very handy.

                  year(date) * 10^4 + month(Date(* 10^2

                  2016016

                  and you can go days

                  year(date) * 10^4 + month(Date(* 10^2 + day(Date)

                  20160614

                  For your question you can query 201606+1 and 201606-1.

                   

                  Might help, might not, but file away somewhere - date "objects" as numbers are very useful.

                   

                  Stephen

                   

                  “My first time in Madagascar was awesome because lemurs are kind of funny; they throw fruit at the back of your head when you’re not looking and then point at one another when you turn around.” ― Kevin Hearne

                  • 6. Re: current month field?
                    keywords

                    That does not matter. A numeral can still be text, and you can still do maths with it. Even if the field also contains text FM will just use the numerals. For example:

                    The calc:  Month ( Get ( CurrentDate ) ) & " ( " & MonthName ( Get ( CurrentDate ) ) & " )"

                    —the result of which right now is:  "6 ( June )"

                    Can still be used in another calc, say: <the field with the above calc> + 1

                    —the result of which will be:  7

                    • 7. Re: current month field?
                      fitch

                      Sometimes it doesn't matter, but sometimes it does. If they set the calc to return a date result, for example. And of course sorting is different for text vs. numbers. So I'd call it a best practice to use the appropriate data type.

                       

                      We need hellkay to elaborate on "not displaying properly."

                      • 8. Re: current month field?
                        siplus

                        do you have data for currentmonth + 1 and currentmonth + 2 of current year ?

                        • 9. Re: current month field?
                          Mike_Mitchell

                          Keep in mind such a calculation must be unstored. Otherwise, it will store the value it had when you closed the Manage Database dialog basically forever (unless you change it there) because Get ( CurrentDate ) doesn't require any local dependencies. (That is, there's nothing forcing it to reevaluate.)

                          • 10. Re: current month field?
                            hellkay

                            Hi

                             

                            thanks for all the input.

                             

                            I want the field to re-evaluate each time the report is run: I guess that would only happen on a new record creation?

                             

                            The purpose of this DB is to manipulate imported data for reporting purposes, so I am effectively deleting and importing on a daily basis.

                             

                            I was hoping to use this current month field to structure the relationships for the various reports mentioned above.

                            • 11. Re: current month field?
                              Mike_Mitchell

                              If that's all you're using it for, a set of global fields, populated by script, might work better.

                              • 12. Re: current month field?
                                hellkay

                                Someone told me you couldn't use global fields in a hosted file, but I'm not sure it this is true...

                                 

                                I'm just a beginner at scripting: would you set a variable as being CurrentDate then go from there?

                                • 13. Re: current month field?
                                  Mike_Mitchell

                                  Not if you need it in a relationship.

                                   

                                  Yes, you can certainly use global fields in a hosted system. They just revert to the value they had when last the file was closed locally (i.e. not hosted). In this case, it won't matter because you're setting them via script anyway.

                                  • 14. Re: current month field?
                                    siplus

                                    hellkay wrote:

                                     

                                    Someone told me you couldn't use global fields in a hosted file, but I'm not sure it this is true...

                                     

                                    Global fields are the key to offering a unique experience to different users accessing the same data pool.

                                     

                                    Whoever told you that has no clue.

                                    1 2 Previous Next