topic Re: How to add current date to config.xml in ArcGIS Viewer for Flex Questions

How to add current date to config.xml

RuyMartinez — Thu, 21 Jul 2011 16:54:01 GMT

Hello Everyone,

I am attempting to add the current date and add it to a query in the config.xml file for the flex viewer.

This works without any problems:

<layer label=???My Date Layer??? type=???feature??? visible=???true??? url=???http://server/arcgis/rest/services/datelayer/FeatureServer/1??? definitionexpression=???date>=???07/21/2011??????/>

I'm looking for something like this:

<layer label=???My Date Layer??? type=???feature??? visible=???true??? url=???http://server/arcgis/rest/services/datelayer/FeatureServer/1??? definitionexpression=???date>=CURRENT_DATE??? />

Has anyone else done something like this?

Thank you,
Ruy

Re: How to add current date to config.xml

RobertScheitlin__GISP — Thu, 21 Jul 2011 17:38:50 GMT

Ruy,

Have you tried GetDate()?

Re: How to add current date to config.xml

RuyMartinez — Thu, 21 Jul 2011 18:00:41 GMT

I've tried

<layer label=�?�My Date Layer�?� type=�?�feature�?� visible=�?�true�?� url=�?�http://server/arcgis/rest/services/datelayer/FeatureServer/1�?� definitionexpression=�?�date>=GetDate()�?�/>

<layer label=�?�My Date Layer�?� type=�?�feature�?� visible=�?�true�?� url=�?�http://server/arcgis/rest/services/datelayer/FeatureServer/1�?� definitionexpression=�?�date>='GetDate()'�?�/>

<layer label=�?�My Date Layer�?� type=�?�feature�?� visible=�?�true�?� url=�?�http://server/arcgis/rest/services/datelayer/FeatureServer/1�?� definitionexpression=�?�date>= + 'GetDate()'�?�/>

and

<layer label=�?�My Date Layer�?� type=�?�feature�?� visible=�?�true�?� url=�?�http://server/arcgis/rest/services/datelayer/FeatureServer/1�?� definitionexpression=�?�date>= + GetDate()�?�/>

None of these combinations work.

Re: How to add current date to config.xml

RobertScheitlin__GISP — Thu, 21 Jul 2011 18:24:10 GMT

Ruy,

What is the underling data for this featureService in (SDE SQL Server or Oracle, Shapefile, FDGB, what)?

Re: How to add current date to config.xml

RuyMartinez — Thu, 21 Jul 2011 18:32:45 GMT

SDE SQL SERVER

Re: How to add current date to config.xml

RobertScheitlin__GISP — Thu, 21 Jul 2011 18:42:03 GMT

Ruy,

OK, CURRENT_DATE keyword is suppose to be supported.

Re: How to add current date to config.xml

RuyMartinez — Sat, 11 Dec 2021 16:45:28 GMT

Robert,

I want to thank you for taking the time to help me out. I'm still stuck on the syntax. Here are the latest attempts

definitionexpression=�?�date>=CURRENT_DATE�?�
definitionexpression=�?�date>=CURRENT_DATE()�?�
definitionexpression=�?�date>= + 'CURRENT_DATE'�?�
definitionexpression=�?�date>= + 'CURRENT_DATE()'�?�

Do I have to format the date before I send it in the query? I'm not sure what else to try.

Ruy

Re: How to add current date to config.xml

RuyMartinez — Thu, 21 Jul 2011 19:07:11 GMT

Okay I finally go something to work!

definitionexpression="date>= DATEADD(d, DATEDIFF(d,0,GETDATE(),0)"

I found the answer here

Thanks for your help on this Robert.
Ruy