Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Ethan0079
Contributor II
Contributor II

Problem of date and string inside a expression condition

Hello,

I have a problem...

My code snippet below works and returns the right date in the right format.

Date(($(vCurrentDate)+'07:00:00'),'DD.MM.YYYY HH:mm:ss')

Ethan0079_0-1666701023299.png

However, I would like to insert this result inside my Count condition.

Ethan0079_1-1666701167678.png

But the interpreter gives me an error. Impossible to understand why, I tried everything.

 

On the other hand, if I write the date and time in hard copy, it works 🙂

Ethan0079_2-1666701329862.png

 

Thanks in advance for your help!

Ethan

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

HI @Ethan0079 

It will be because it is trying to evaluate against the actual text for the date function in the set expression and not the what is being returned from the Date Function. you will need something like

Date  = {'$(Date(.....))'}

Ethan0079
Contributor II
Contributor II
Author

That doesn't work 😪