Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Wilhelm Kabus]

Hi! In this version my expression column formula no longer works. Displaying "Expression Error":

s-math(
FormatNumber( Now(),0)
-
FormatNumber( ConvertDate([played],0)))

Used to give me # of days since last played :-)

[Matt]

Hi! In this version my expression column formula no longer works. Displaying "Expression Error":

s-math(
FormatNumber( Now(),0)
-
FormatNumber( ConvertDate([played],0)))

Used to give me # of days since last played :-)

I think your date is already the internal format so doing ConvertDate won't work.

Maybe something like this:
CompareDates([Last Played, 0], Now(), d)

[Wilhelm Kabus]

I think your date is already the internal format so doing ConvertDate won't work.

Maybe something like this:
CompareDates([Last Played, 0], Now(), d)

But it worked fine in many previous versions. You don't want to support my formula anymore, Matt?

[Matt]

But it worked fine in many previous versions. You don't want to support my formula anymore, Matt?

It's just because there are a couple parameters to the ConverDate function but it only takes one.  I can switch to just ignoring the extra parameters in the next build.

[zybex]

Maybe you meant ConvertDate([played,0])) ?

ConvertDate([played],0)) is wrong and was always wrong - it just worked because the second argument (0) was ignored, which is no longer the case.

[Wilhelm Kabus]

No need, Matt... I removed it. Works now...