fetch date in workflow query activity

[nidhiv77838491]

Hi,

Can anyone help me in fetch the current date using the query activity . When i am using GetDate(), GetDateTime() function in the same showing formate as - 13-OCT-17 11.34.43.032630000 AM when i am trying to see the date from the list using the temporary table created in database for the list.

Please help me out in the same.

Regards,

Nidhi

[florentlb]

Hi Nidhi,

What is you exact need here? GetDate and GetDateTime functions allow to retrieve the date and time at the moment the query is executed. What is the result you expect?

Let me know,

Florent

[nidhiv77838491]

Hi florent​,

Actually, i want only date  that needs to be display ..but not to see that function in query component.

Thanks,

Nidhi

[florentlb]

Hi Nidhi,

I don't understand. In your first post you seem to be able to see the date "13-OCT-17 11.34.43.032630000 AM". Can you share a screenshot of what you are seeing?

Thank you,

Florent

[florentlb]

Hi Nidhi,

Any update on this?

Florent