How to convert date from MM/DD/YYYY to YYYY-MM-DD format?

Help Studio
, ,
1

Hello,

As my title states, I need help converting from MM/DD/YYYY HH:MM:SS to YYYY-MM-DD format. Please help! :slight_smile:

Thank you!

2

Hi,

Can you try the following expression?

DateTime.Parse(yourDateString).ToString("yyyy-MM-dd")

image

Regards,

3

Hi, thank you for your response! I have a follow up question - let’s say I will need to sometimes subtract this date -1day or -90 days, where I am pulling the number from the config file, how would I do it?

4

Hi,

Can you try to add .AddDays(-90) for eaxmple as the following?

DateTime.Parse(yourDateString).AddDays(-90).ToString("yyyy-MM-dd")

image

Regards,

5

What if the -90 value is being extracted from the config file as it needs to be customizable?

6

I am receiving an error when storing the value (-90) that I am extracting from config file into a string

7

Can you try as the following?

DateTime.Parse(dateTimeString).AddDays(CInt(in_Config("someKey").ToString)).ToString("yyyy-MM-dd")
1 Like
8

It works, thank you so much!

1 Like