Date Format

[Hiteshp]

Hello,

How do i get to join the start date and end date of the week in mm/dd - mm/dd format, with the condition week starting on a Monday.

In the Attach example i would like to get the date in 06/26-07/03 format.

Thank you.

[DavidSkaife · Accepted solution]

Hi @Hiteshp 

something like this?

Use the following code in a Formula tool, on the assumption that the start/end dates are in date format:

DateTimeFormat([Start Week],'%m/%d')+'-'+DateTimeFormat([End Week],'%m/%d')

[Hiteshp]

Hello David,

Thank you for your response, I do have the start/end dates in date format, however i am still unable to get the desired results.

[caltang · Accepted solution]

@Hiteshp it's because your field "Week" has a data type of "Date". Kindly change it to "V_WString" and you will get your desired output.