Get date as number
Dumb question - how do you convert or get the number value of a date?
If I am reading this correctly, you want the date to be yyyymm. If that is correct, then what you are looking to get is:
Year ( get(CurrentDate)) & right ("0" & month ( get(CurrentDate)),2)
The piece you are wanting is the leading ZERO on single digit months.
The number value, as in the number of days from the date shown to 12/31/0000?
Simply refer to the field as a number.
GetAsNumber ( DateField )
is one way.
My idea was flawed. Thanks for the answer but lets try another way.
This is my formula.
Let ([y=MPR::Month];Year(y)) & Let([zz=MPR::Month];Month ( zz ))
Let ([x=Get (CurrentDate)];Year(x)) & Let([w=Get ( CurrentDate )];Month(w))
Note this script is not run regularly, and now i found a bug.
If MPR::Month is Feb 2014, it returns 20142. When running the script CurrentDate today returns 201410 making it then lower then MPR::Month.
So i guess my question is how to i get 20142 to 201402?
Retrieving data ...