Date and Time for UI path studio automation

[jnarthan.g (Jnarthan)]

Hi there, I need a help for UI path automation.
I want to create a logic about start time and end date.
How do I create for this below :

If Date < 7th of current month
Start date = 1st of previous month
End date = 20th of current month

Else If Date > 7th of current month
Start date = 1st of current month
End date = Last day of current month

Can someone give me an answer to this?
Really could need some help.

[raja.arslankhan]

@jnarthan.g
Let me check
DateTime.xaml (7.8 KB)
Post Updated

[Yoichi]

Hi,

How about the following sample? We can achieve it using ModifyDate activity.

Sample20230310-3L.zip (2.8 KB)

Regards,

[Suraj_B_Shetty (Suraj)]

Hi @jnarthan.g

Give a try to this
DateTime.xaml (7.6 KB)

Hope this helps.

[jnarthan.g (Jnarthan)]

Let me have a look ya. Will reply in a while

[jnarthan.g (Jnarthan)]

Alright. Thank you very much ya. Let me have a look and try it and get back to you.

[jnarthan.g (Jnarthan)]

Really helps a lot. Really much appreciated.

Thank you.

Regards.

[raja.arslankhan]

@jnarthan.g post updated

[jnarthan.g (Jnarthan)]

Hi do you happen to know how to extract date from outlook email?
Could you help me out?
The one that you send its been successful. But I need a way to extract the date from the outlook email with the below code that you send me.

If Date < 7th of current month
Start date = 1st of previous month
End date = 20th of current month

Else If Date > 7th of current month
Start date = 1st of current month
End date = Last day of current month

[Suraj_B_Shetty (Suraj)]

Hi @jnarthan.g
Give a try to this
mailMessage.Headers(“Date”)

[jnarthan.g (Jnarthan)]

Sorry I don’t get you. Where should I insert this ?

[Suraj_B_Shetty (Suraj)]

Hi @jnarthan.g
mailMessage has list of mail available. Loop through this and get the required mail date.

[jnarthan.g (Jnarthan)]

Hi bro thanks and it was success the one you gave me.
Do you know how to link this code to email?

The date suppose to be extract from the email.
Do you have any ideas to do so.

Regards,

[raja.arslankhan]

@jnarthan.g

If you want to get date for all emails then you need to put mailmessages over loop.

[raja.arslankhan]

@jnarthan.g
updated code.
DateTime.xaml (9.6 KB)

[raja.arslankhan]

@jnarthan.g
Code for each email.
DateTime.xaml (11.9 KB)