Expand my Community achievements bar.

SOLVED

Date field problem

Avatar

Level 4

Hi there

I have placed in my form two date fields, one that displays the current date and one with a date that i have set as default.  What I want the form to do is check if the current date is greater than the default date I input.

Could anyone help.  Also for my knowledge how do I reference the current date as a Date2Num in another field.

Many thanks for any help.

Darren

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

Comparing Dates is always a tricky affair. You have to get the dates into a common arithmetic format (usually the date is converted into a number of milliseconds that have elapsed since a point in time - called an epoc) . FormCalc has some nice functions to help you with this (it can be done with Javascript but it is more tedious). I have included a couple of date arithemtic samples that I had kicking around.

paul

View solution in original post

2 Replies

Avatar

Correct answer by
Former Community Member

Comparing Dates is always a tricky affair. You have to get the dates into a common arithmetic format (usually the date is converted into a number of milliseconds that have elapsed since a point in time - called an epoc) . FormCalc has some nice functions to help you with this (it can be done with Javascript but it is more tedious). I have included a couple of date arithemtic samples that I had kicking around.

paul

Avatar

Level 4

That is great Paul.  Many thanks for your help and example

s.

Darren

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----