Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

fetch date in workflow query activity

Avatar

Avatar
Validate 1
Level 2
nidhiv77838491
Level 2

Likes

6 likes

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
nidhiv77838491
Level 2

Likes

6 likes

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
nidhiv77838491
Level 2

13-10-2017

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

13-11-2017

Hi Nidhi,

Any update on this?

Florent

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

31-10-2017

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

Avatar

Avatar
Validate 1
Level 2
nidhiv77838491
Level 2

Likes

6 likes

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
nidhiv77838491
Level 2

Likes

6 likes

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
nidhiv77838491
Level 2

22-10-2017

Hi florent​,

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

Thanks,

Nidhi

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

18-10-2017

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