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: =???07/21/2011??????/> I'm looking for something like this: =CURRENT_DATE??? /> Has anyone else done something like this? Thank you, Ruy

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to add current date to config.xml

RuyMartinez

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

Najděte více příspěvků označených jako

Accepted answers

All comments

RuyMartinez

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

RuyMartinez

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

RobertScheitlin__GISP

Ruy,

OK, CURRENT_DATE keyword is suppose to be supported.

RuyMartinez

SDE SQL SERVER

RobertScheitlin__GISP

Ruy,

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

RuyMartinez

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.

RobertScheitlin__GISP

Ruy,

Have you tried GetDate()?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.